Product: | OE - Order Entry |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.SO_PICKING_LINE_DETAILS_V |
SELECT DISTINCT SPLD.ROWID ROW_ID
, SPLD.PICKING_LINE_DETAIL_ID
, SPLD.CREATION_DATE
, SPLD.CREATED_BY
, SPLD.LAST_UPDATE_DATE
, SPLD.LAST_UPDATED_BY
, SPLD.LAST_UPDATE_LOGIN
, SPLD.PROGRAM_APPLICATION_ID
, SPLD.PROGRAM_ID
, SPLD.PROGRAM_UPDATE_DATE
, SPLD.REQUEST_ID
, SPLD.PICKING_LINE_ID
, SPH.PICK_SLIP_NUMBER
, SPL.SEQUENCE_NUMBER
, SPL.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') SUBINV_RESTRICTED_FLAG
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N') REVISION_CONTROL_FLAG
, DECODE(MSI.LOT_CONTROL_CODE
, 2
, 'Y'
, 3
, 'Y'
, 'N') LOT_CONTROL_FLAG
, DECODE(MSI.SERIAL_NUMBER_CONTROL_CODE
, 2
, 'Y'
, 5
, 'Y'
, 6
, DECODE(SOH.ORDER_CATEGORY
, 'P'
, 'N'
, 'D')
, 'N') SERIAL_NUMBER_CONTROL_FLAG
, SPLD.REQUESTED_QUANTITY
, SPLD.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, SPLD.SHIPPED_QUANTITY
, SPL.UNIT_CODE
, MSI.PRIMARY_UOM_CODE
, SPLD.SERIAL_NUMBER
, SPLD.LOT_NUMBER
, SPLD.CUSTOMER_REQUESTED_LOT_FLAG
, SPLD.REVISION
, SPLD.SUBINVENTORY
, SPLD.INVENTORY_LOCATION_ID
, SPLD.SEGMENT1
, SPLD.SEGMENT2
, SPLD.SEGMENT3
, SPLD.SEGMENT4
, SPLD.SEGMENT5
, SPLD.SEGMENT6
, SPLD.SEGMENT7
, SPLD.SEGMENT8
, SPLD.SEGMENT9
, SPLD.SEGMENT10
, SPLD.SEGMENT11
, SPLD.SEGMENT12
, SPLD.SEGMENT13
, SPLD.SEGMENT14
, SPLD.SEGMENT15
, SPLD.SEGMENT16
, SPLD.SEGMENT17
, SPLD.SEGMENT18
, SPLD.SEGMENT19
, SPLD.SEGMENT20
, SPLD.INVENTORY_LOCATION_SEGMENTS
, SPLD.DETAIL_TYPE_CODE
, SPLD.CONTEXT
, SPLD.ATTRIBUTE1
, SPLD.ATTRIBUTE2
, SPLD.ATTRIBUTE3
, SPLD.ATTRIBUTE4
, SPLD.ATTRIBUTE5
, SPLD.ATTRIBUTE6
, SPLD.ATTRIBUTE7
, SPLD.ATTRIBUTE8
, SPLD.ATTRIBUTE9
, SPLD.ATTRIBUTE10
, SPLD.ATTRIBUTE11
, SPLD.ATTRIBUTE12
, SPLD.ATTRIBUTE13
, SPLD.ATTRIBUTE14
, SPLD.ATTRIBUTE15
, SPLD.RELEASED_FLAG
, SPLD.SCHEDULE_DATE
, SPLD.SCHEDULE_LEVEL
, SPLD.SCHEDULE_STATUS_CODE
, SPLD.DEMAND_ID
, SPLD.AUTOSCHEDULED_FLAG
, SPLD.DELIVERY
, SPLD.WIP_RESERVED_QUANTITY
, SPLD.WIP_COMPLETED_QUANTITY
, SPLD.SUPPLY_SOURCE_TYPE
, SPLD.SUPPLY_SOURCE_HEADER_ID
, SPLD.UPDATE_FLAG
, SPLD.DEMAND_CLASS_CODE
, SPLD.RESERVABLE_FLAG
, SPLD.TRANSACTABLE_FLAG
, SPLD.LATEST_ACCEPTABLE_DATE
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, MTL_SYSTEM_ITEMS_VL MSI
, SO_HEADERS_ALL SOH
, SO_PICKING_HEADERS SPH
, SO_PICKING_LINES SPL
, SO_PICKING_LINE_DETAILS SPLD
WHERE SPL.PICKING_LINE_ID = SPLD.PICKING_LINE_ID
AND SPH.PICKING_HEADER_ID = SPL.PICKING_HEADER_ID
AND MSI.INVENTORY_ITEM_ID = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = SPLD.WAREHOUSE_ID
AND ORG.ORGANIZATION_ID = SPLD.WAREHOUSE_ID
AND SOH.HEADER_ID = SPH.ORDER_HEADER_ID