Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT TO_CHAR(SHIP_ADDRESS.ADDRESS_ID)|| RHX_DP.GET_PARAMETER( 'RHX_DP_P_DELIMITER')|| SHIP_ADDRESS.ADDRESS1
, TO_CHAR(SHIP_TERRITORY.TERRITORY_ID)|| DECODE(SHIP_TERRITORY.NAME
, NULL
, NULL
, RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER'))|| SHIP_TERRITORY.NAME
, TO_CHAR(BILL_ADDRESS.ADDRESS_ID)|| RHX_DP.GET_PARAMETER( 'RHX_DP_P_DELIMITER')|| BILL_ADDRESS.ADDRESS1
, TO_CHAR(BILL_TERRITORY.TERRITORY_ID)|| DECODE(BILL_TERRITORY.NAME
, NULL
, NULL
, RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER'))|| BILL_TERRITORY.NAME
, RDLW.WEEK
, MSIK.CONCATENATED_SEGMENTS|| RHX_DP.GET_PARAMETER( 'RHX_DP_P_DELIMITER')|| MP.ORGANIZATION_CODE
, MSIK.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, SUM(NVL(SLA.ORDERED_QUANTITY
, 0)) QUANTITY
, FCL.MEANING
, SLA.CONTEXT
, SLA.ATTRIBUTE1
, SLA.ATTRIBUTE2
, SLA.ATTRIBUTE3
, SLA.ATTRIBUTE4
, SLA.ATTRIBUTE5
, SLA.ATTRIBUTE6
, SLA.ATTRIBUTE7
, SLA.ATTRIBUTE8
, SLA.ATTRIBUTE9
, SLA.ATTRIBUTE10
, SLA.ATTRIBUTE11
, SLA.ATTRIBUTE12
, SLA.ATTRIBUTE13
, SLA.ATTRIBUTE14
, SLA.ATTRIBUTE15
FROM OE_ORDER_HEADERS_ALL SHA
, OE_ORDER_LINES_ALL SLA
, RA_SITE_USES_ALL SHIP
, RA_SITE_USES_ALL BILL
, RA_ADDRESSES_ALL SHIP_ADDRESS
, RA_ADDRESSES_ALL BILL_ADDRESS
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_PARAMETERS MP
, RA_TERRITORIES BILL_TERRITORY
, RA_TERRITORIES SHIP_TERRITORY
, RHX_DP_L_WEEKS_V RDLW
, FND_COMMON_LOOKUPS FCL
WHERE SHA.BOOKED_FLAG = 'Y'
AND FCL.LOOKUP_TYPE(+)='DEMAND_CLASS'
AND FCL.LOOKUP_CODE(+)=SLA.DEMAND_CLASS_CODE
AND SLA.HEADER_ID=SHA.HEADER_ID
AND SHA.SHIP_TO_ORG_ID=SHIP.SITE_USE_ID
AND SHIP.ADDRESS_ID=SHIP_ADDRESS.ADDRESS_ID
AND SHA.INVOICE_TO_ORG_ID=BILL.SITE_USE_ID
AND BILL.ADDRESS_ID=BILL_ADDRESS.ADDRESS_ID
AND BILL.TERRITORY_ID=BILL_TERRITORY.TERRITORY_ID(+)
AND SHIP.TERRITORY_ID=SHIP_TERRITORY.TERRITORY_ID(+)
AND MSIK.ORGANIZATION_ID=SLA.SHIP_FROM_ORG_ID
AND MSIK.INVENTORY_ITEM_ID=SLA.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID=MSIK.ORGANIZATION_ID
AND SLA.SCHEDULE_SHIP_DATE >= RDLW.START_DATE
AND SLA.SCHEDULE_SHIP_DATE <= RDLW.END_DATE
AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT' GROUP BY TO_CHAR(SHIP_ADDRESS.ADDRESS_ID)|| RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| SHIP_ADDRESS.ADDRESS1
, TO_CHAR(SHIP_TERRITORY.TERRITORY_ID)|| DECODE(SHIP_TERRITORY.NAME
, NULL
, NULL
, RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER'))|| SHIP_TERRITORY.NAME
, TO_CHAR(BILL_ADDRESS.ADDRESS_ID)|| RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| BILL_ADDRESS.ADDRESS1
, TO_CHAR(BILL_TERRITORY.TERRITORY_ID)|| DECODE(BILL_TERRITORY.NAME
, NULL
, NULL
, RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER'))|| BILL_TERRITORY.NAME
, RDLW.WEEK
, MSIK.CONCATENATED_SEGMENTS|| RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| MP.ORGANIZATION_CODE
, MSIK.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, FCL.MEANING
, SLA.CONTEXT
, SLA.ATTRIBUTE1
, SLA.ATTRIBUTE2
, SLA.ATTRIBUTE3
, SLA.ATTRIBUTE4
, SLA.ATTRIBUTE5
, SLA.ATTRIBUTE6
, SLA.ATTRIBUTE7
, SLA.ATTRIBUTE8
, SLA.ATTRIBUTE9
, SLA.ATTRIBUTE10
, SLA.ATTRIBUTE11
, SLA.ATTRIBUTE12
, SLA.ATTRIBUTE13
, SLA.ATTRIBUTE14
, SLA.ATTRIBUTE15