GMD Certificate of Analysis/Certificate of Conformance(New Quality)

➜ Back to Library
Description
Categories: BI Publisher
Application: Process Manufacturing Product Development
Source: Certificate of Analysis/Certificate of Conformance(New Quality) (XML)
Short Name: QCRCOA02_XML
DB package: GMD_QCRCOA03_XMLP_PKG
Run GMD Certificate of Analysis/Certificate of Conformance(New Quality) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ALL GMD_COA_HEADERS.GMD_COA_ID, GMD_COA_HEADERS.ORDER_ID, GMD_COA_HEADERS.LINE_ID, 
GMD_COA_HEADERS.ORGANIZATION_CODE, GMD_COA_HEADERS.ORDER_NO, 
GMD_COA_HEADERS.CUSTPO_NO, GMD_COA_HEADERS.SHIPDATE, GMD_COA_HEADERS.CUST_ID, 
GMD_COA_HEADERS.CUST_NO, substrb(GMD_COA_HEADERS.CUST_NAME,1,68) cust_name, GMD_COA_HEADERS.BOL_ID, 
GMD_COA_HEADERS.BOL_NO, GMD_COA_HEADERS.INVENTORY_ITEM_ID, GMD_COA_HEADERS.ITEM_NUMBER, 
GMD_COA_HEADERS.ITEM_DESCRIPTION, GMD_COA_HEADERS.REVISION, GMD_COA_HEADERS.SUBINVENTORY, 
GMD_COA_HEADERS.LOT_NUMBER, NULL SUBLOT, GMD_COA_HEADERS.LOT_DESCRIPTION, 
GMD_COA_HEADERS.ORDER_QTY1, GMD_COA_HEADERS.ORDER_UOM1, 
GMD_COA_HEADERS.ORDER_QTY2, GMD_COA_HEADERS.ORDER_UOM2, GMD_COA_HEADERS.SHIP_QTY1, 
GMD_COA_HEADERS.SHIP_QTY2, GMD_COA_HEADERS.SHIP_QTY_UOM1, GMD_COA_HEADERS.SHIP_QTY_UOM2, GMD_COA_HEADERS.REPORT_TITLE, GMD_COA_HEADERS.SESSION_ID,
GMD_COA_HEADERS.SPEC_HDR_TEXT_CODE, 
	GMD_QCRCOA03_XMLP_PKG.cf_report_nameformula(GMD_COA_HEADERS.REPORT_TITLE) CF_report_name
FROM GMD_COA_HEADERS
Parameter Name SQL text Validation
Print_Text_Flag 
 
 Number
p_organization_id 
 
 Number
p_inventory_item_id 
 
 Number
p_revision 
 
 Char
p_lot_number 
 
 Char
p_subinventory 
 
 Char
p_cust_id 
 
 Number
p_order_id 
 
 Number
p_delivery_id 
 
 Number
p_org_id 
 
 Number
p_sampling_event_id 
 
 Number
p_spec_id 
 
 Number
p_ship_to_site_id 
 
 Number
Download
Related Blitz Reports
GMD Customer/Supplier Test Results GMD Item/Location Test Results GMD Production Test Results OPM WIP Value - V2 OPM2 GME OPM Outside Processing PA Supplier Cost Audit GMF Create Accounting PA Create Accounting
Blitz Report™

Blitz Report™ provides multiple benefits: