FND Design Data [Home] [Help]

View: SO_SCHEDULE_DETAILS

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.SO_SCHEDULE_DETAILS
View Text

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

Columns

Name
LINE_ID
OPTION_LINE_NUMBER
PARENT_LINE_ID
COMPONENT_CODE
INVENTORY_ITEM_ID
QUANTITY
RATIO
DESCRIPTION
ROW_LEVEL
ID_COLUMN
RECEIPT_STATUS
SOURCE_TYPE
END_ITEM_UNIT_NUMBER