Tutorial Videos
SELECT SH.ORDER_NUMBER,
TH.NAME GG_ORDER_NUMBER,
SL.LINE_NUMBER||'.'||SL.SHIPMENT_NUMBER||'.'||SL.OPTION_NUMBER||'.'||SL.COMPONENT_NUMBER SO_LINE,
MTL.SEGMENT1 PART_NUMBER,
TL.REQUESTED_QUANTITY QUANTITY,
RC.CUSTOMER_NUMBER,
TH.FREIGHT_CARRIER SHIPPING_METHOD,
RA.ATTRIBUTE15 COMPANY,
MTL.ITEM_TYPE,
RS.LOCATION,
TH.ATTRIBUTE12 CUSTOMS_DATE,
SL.ACTUAL_SHIPMENT_DATE,
TL.DELIVERY_DETAIL_ID,
SH.HEADER_ID SO_HEADER_ID,
SL.LINE_ID SO_LINE_ID,
SH.TP_ATTRIBUTE1 HEADER_EDI_QUOTE_NO,
SH.TP_ATTRIBUTE5 HEADER_QUOTE_ID,
SH.TP_ATTRIBUTE15 HEADER_OPPORTUNITY_ID,
SL.TP_ATTRIBUTE12 LINE_OPPORTUNITY_ID,
SL.TP_ATTRIBUTE13 LINE_QUOTE_ID,
SL.TP_ATTRIBUTE15 QUOTE_LINE_ID
FROM MOE_DELIVERIES_V TH,
WSH_DLVY_DELIVERABLES_V TL,
OE_ORDER_LINES_ALL SL,
OE_ORDER_HEADERS_ALL SH,
RA_ADDRESSES_ALL RA,
RA_SITE_USES_ALL RS,
MTL_SYSTEM_ITEMS MTL,
RA_CUSTOMERS RC
WHERE TH.DELIVERY_ID = TL.DELIVERY_ID
AND TL.SOURCE_LINE_ID = SL.LINE_ID
AND SH.HEADER_ID = SL.HEADER_ID
AND RA.CUSTOMER_ID = TH.CUSTOMER_ID
AND RA.CUSTOMER_ID = RC.CUSTOMER_ID
AND RS.ADDRESS_ID = RA.ADDRESS_ID
AND RS.SITE_USE_ID = TH.SHIP_TO
AND MTL.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
AND MTL.ORGANIZATION_ID = TL.ORGANIZATION_ID
-- AND SL.ACTUAL_SHIPMENT_DATE >= TO_DATE(:DATECODE1,'YYYY/MM/DD')
-- AND SL.ACTUAL_SHIPMENT_DATE <= TO_DATE(:DATECODE2,'YYYY/MM/DD')+3
-- AND SL.FLOW_STATUS_CODE = 'CLOSED'
-- AND SH.ORG_ID = :ORG_ID
AND TH.NAME='GG1023A02525'