eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.SO_SCHEDULE_DETAILS

Source

View Text - Preformatted


SELECT L.LINE_ID LINE_ID , DECODE(L.PARENT_LINE_ID,'','',L.LINE_NUMBER) OPTION_LINE_NUMBER , L.PARENT_LINE_ID PARENT_LINE_ID , LD.COMPONENT_CODE COMPONENT_CODE , LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , L.ORDERED_QUANTITY*LD.COMPONENT_RATIO QUANTITY , LD.COMPONENT_RATIO RATIO , MSI.DESCRIPTION DESCRIPTION , 0 ROW_LEVEL , L.LINE_ID ID_COLUMN , LUP.MEANING RECEIPT_STATUS , LUP1.MEANING SOURCE_TYPE , L.END_ITEM_UNIT_NUMBER FROM SO_LINES L , SO_LINE_DETAILS LD , MTL_SYSTEM_ITEMS_VL MSI , SO_LOOKUPS LUP , SO_LOOKUPS LUP1 WHERE L.LINE_ID = LD.LINE_ID AND MSI.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID') AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS' AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE' AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT L.LINE_ID LINE_ID , DECODE(L.PARENT_LINE_ID,'','',L.LINE_NUMBER) OPTION_LINE_NUMBER , L.PARENT_LINE_ID PARENT_LINE_ID , LD.COMPONENT_CODE COMPONENT_CODE , LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , LD.QUANTITY QUANTITY , LD.COMPONENT_RATIO RATIO , '  ' || OD.ORGANIZATION_CODE || ' ' || LD.SCHEDULE_DATE || ' ' || LD.REVISION || ' ' || LD.LOT_NUMBER || ' ' || LD.SUBINVENTORY DESCRIPTION , 1 ROW_LEVEL , LD.LINE_DETAIL_ID ID_COLUMN , LUP.MEANING RECEIPT_STATUS , LUP1.MEANING SOURCE_TYPE , L.END_ITEM_UNIT_NUMBER FROM SO_LINES L , SO_LINE_DETAILS LD , MTL_PARAMETERS OD , SO_LOOKUPS LUP , SO_LOOKUPS LUP1 WHERE L.LINE_ID = LD.LINE_ID AND LD.WAREHOUSE_ID = OD.ORGANIZATION_ID AND NVL(LD.RELEASED_FLAG,'N') = 'N' AND NVL(LD.SCHEDULE_STATUS_CODE,'NULL') != 'SUPPLY RESERVED' AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS' AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE' AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT L.LINE_ID LINE_ID , DECODE(L.PARENT_LINE_ID,'','',L.LINE_NUMBER) OPTION_LINE_NUMBER , L.PARENT_LINE_ID PARENT_LINE_ID , LD.COMPONENT_CODE COMPONENT_CODE , LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , LD.QUANTITY QUANTITY , LD.COMPONENT_RATIO RATIO , '  ' || ' ' || ' ' || LD.SCHEDULE_DATE || ' ' || LD.REVISION || ' ' || LD.LOT_NUMBER || ' ' || LD.SUBINVENTORY DESCRIPTION , 1 ROW_LEVEL , LD.LINE_DETAIL_ID ID_COLUMN , LUP.MEANING RECEIPT_STATUS , LUP1.MEANING SOURCE_TYPE , L.END_ITEM_UNIT_NUMBER FROM SO_LINES L , SO_LINE_DETAILS LD , SO_LOOKUPS LUP , SO_LOOKUPS LUP1 WHERE L.LINE_ID = LD.LINE_ID AND LD.WAREHOUSE_ID IS NULL AND NVL(LD.RELEASED_FLAG,'N') = 'N' AND NVL(LD.SCHEDULE_STATUS_CODE,'NULL') != 'SUPPLY RESERVED' AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS' AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE' AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT PL.ORDER_LINE_ID LINE_ID , DECODE(L.PARENT_LINE_ID,'','',L.LINE_NUMBER) OPTION_LINE_NUMBER , L.PARENT_LINE_ID PARENT_LINE_ID , PL.COMPONENT_CODE COMPONENT_CODE , PL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , PLD.REQUESTED_QUANTITY QUANTITY , PL.COMPONENT_RATIO RATIO , '  ' || OD.ORGANIZATION_CODE || ' ' || PLD.SCHEDULE_DATE || ' ' || PLD.REVISION || ' ' || PLD.LOT_NUMBER || ' ' || PLD.SUBINVENTORY DESCRIPTION , 2 ROW_LEVEL , PLD.PICKING_LINE_DETAIL_ID ID_COLUMN , TO_CHAR(NULL) , LUP1.MEANING SOURCE_TYPE , L.END_ITEM_UNIT_NUMBER FROM SO_PICKING_LINES PL , SO_PICKING_LINE_DETAILS PLD , SO_LINES L , MTL_PARAMETERS OD , SO_LOOKUPS LUP1 WHERE PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID AND PLD.WAREHOUSE_ID = OD.ORGANIZATION_ID(+) AND PL.ORDER_LINE_ID = L.LINE_ID AND PL.PICKING_HEADER_ID = 0 AND NVL(PLD.RELEASED_FLAG,'N') = 'N' AND NVL(PLD.SCHEDULE_STATUS_CODE,'NULL') != 'SUPPLY RESERVED' AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE' AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE

View Text - HTML Formatted

SELECT L.LINE_ID LINE_ID
, DECODE(L.PARENT_LINE_ID
, ''
, ''
, L.LINE_NUMBER) OPTION_LINE_NUMBER
, L.PARENT_LINE_ID PARENT_LINE_ID
, LD.COMPONENT_CODE COMPONENT_CODE
, LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, L.ORDERED_QUANTITY*LD.COMPONENT_RATIO QUANTITY
, LD.COMPONENT_RATIO RATIO
, MSI.DESCRIPTION DESCRIPTION
, 0 ROW_LEVEL
, L.LINE_ID ID_COLUMN
, LUP.MEANING RECEIPT_STATUS
, LUP1.MEANING SOURCE_TYPE
, L.END_ITEM_UNIT_NUMBER
FROM SO_LINES L
, SO_LINE_DETAILS LD
, MTL_SYSTEM_ITEMS_VL MSI
, SO_LOOKUPS LUP
, SO_LOOKUPS LUP1
WHERE L.LINE_ID = LD.LINE_ID
AND MSI.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID')
AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS'
AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE
AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT L.LINE_ID LINE_ID
, DECODE(L.PARENT_LINE_ID
, ''
, ''
, L.LINE_NUMBER) OPTION_LINE_NUMBER
, L.PARENT_LINE_ID PARENT_LINE_ID
, LD.COMPONENT_CODE COMPONENT_CODE
, LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LD.QUANTITY QUANTITY
, LD.COMPONENT_RATIO RATIO
, ' ' || OD.ORGANIZATION_CODE || ' ' || LD.SCHEDULE_DATE || ' ' || LD.REVISION || ' ' || LD.LOT_NUMBER || ' ' || LD.SUBINVENTORY DESCRIPTION
, 1 ROW_LEVEL
, LD.LINE_DETAIL_ID ID_COLUMN
, LUP.MEANING RECEIPT_STATUS
, LUP1.MEANING SOURCE_TYPE
, L.END_ITEM_UNIT_NUMBER
FROM SO_LINES L
, SO_LINE_DETAILS LD
, MTL_PARAMETERS OD
, SO_LOOKUPS LUP
, SO_LOOKUPS LUP1
WHERE L.LINE_ID = LD.LINE_ID
AND LD.WAREHOUSE_ID = OD.ORGANIZATION_ID
AND NVL(LD.RELEASED_FLAG
, 'N') = 'N'
AND NVL(LD.SCHEDULE_STATUS_CODE
, 'NULL') != 'SUPPLY RESERVED'
AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS'
AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE
AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT L.LINE_ID LINE_ID
, DECODE(L.PARENT_LINE_ID
, ''
, ''
, L.LINE_NUMBER) OPTION_LINE_NUMBER
, L.PARENT_LINE_ID PARENT_LINE_ID
, LD.COMPONENT_CODE COMPONENT_CODE
, LD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LD.QUANTITY QUANTITY
, LD.COMPONENT_RATIO RATIO
, ' ' || ' ' || ' ' || LD.SCHEDULE_DATE || ' ' || LD.REVISION || ' ' || LD.LOT_NUMBER || ' ' || LD.SUBINVENTORY DESCRIPTION
, 1 ROW_LEVEL
, LD.LINE_DETAIL_ID ID_COLUMN
, LUP.MEANING RECEIPT_STATUS
, LUP1.MEANING SOURCE_TYPE
, L.END_ITEM_UNIT_NUMBER
FROM SO_LINES L
, SO_LINE_DETAILS LD
, SO_LOOKUPS LUP
, SO_LOOKUPS LUP1
WHERE L.LINE_ID = LD.LINE_ID
AND LD.WAREHOUSE_ID IS NULL
AND NVL(LD.RELEASED_FLAG
, 'N') = 'N'
AND NVL(LD.SCHEDULE_STATUS_CODE
, 'NULL') != 'SUPPLY RESERVED'
AND LUP.LOOKUP_TYPE(+) = 'RECEIPT STATUS'
AND LUP.LOOKUP_CODE(+) = LD.RECEIPT_STATUS_CODE
AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE UNION SELECT PL.ORDER_LINE_ID LINE_ID
, DECODE(L.PARENT_LINE_ID
, ''
, ''
, L.LINE_NUMBER) OPTION_LINE_NUMBER
, L.PARENT_LINE_ID PARENT_LINE_ID
, PL.COMPONENT_CODE COMPONENT_CODE
, PL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PLD.REQUESTED_QUANTITY QUANTITY
, PL.COMPONENT_RATIO RATIO
, ' ' || OD.ORGANIZATION_CODE || ' ' || PLD.SCHEDULE_DATE || ' ' || PLD.REVISION || ' ' || PLD.LOT_NUMBER || ' ' || PLD.SUBINVENTORY DESCRIPTION
, 2 ROW_LEVEL
, PLD.PICKING_LINE_DETAIL_ID ID_COLUMN
, TO_CHAR(NULL)
, LUP1.MEANING SOURCE_TYPE
, L.END_ITEM_UNIT_NUMBER
FROM SO_PICKING_LINES PL
, SO_PICKING_LINE_DETAILS PLD
, SO_LINES L
, MTL_PARAMETERS OD
, SO_LOOKUPS LUP1
WHERE PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
AND PLD.WAREHOUSE_ID = OD.ORGANIZATION_ID(+)
AND PL.ORDER_LINE_ID = L.LINE_ID
AND PL.PICKING_HEADER_ID = 0
AND NVL(PLD.RELEASED_FLAG
, 'N') = 'N'
AND NVL(PLD.SCHEDULE_STATUS_CODE
, 'NULL') != 'SUPPLY RESERVED'
AND LUP1.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND LUP1.LOOKUP_CODE(+) = L.SOURCE_TYPE_CODE