Product: | OE - Order Entry |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.SO_PICKING_LINES_V |
SELECT DISTINCT SPL.ROWID ROW_ID
, SPL.PICKING_LINE_ID
, SPL.CREATION_DATE
, SPL.CREATED_BY
, SPL.LAST_UPDATE_DATE
, SPL.LAST_UPDATED_BY
, SPL.LAST_UPDATE_LOGIN
, SPL.PROGRAM_APPLICATION_ID
, SPL.PROGRAM_ID
, SPL.PROGRAM_UPDATE_DATE
, SPL.REQUEST_ID
, SPL.PICKING_HEADER_ID
, SPH.PICK_SLIP_NUMBER
, SPL.SEQUENCE_NUMBER
, SPL.ORDER_LINE_ID
, SPL.COMPONENT_CODE
, SPL.LINE_DETAIL_ID
, SPL.COMPONENT_RATIO
, SPL.REQUESTED_QUANTITY
, 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
, SPL.INCLUDED_ITEM_FLAG
, DECODE(MSI.RESERVABLE_TYPE
, 1
, 'Y'
, 'N') RESERVABLE_FLAG
, SPL.DATE_REQUESTED
, SPL.ORIGINAL_REQUESTED_QUANTITY
, SPL.WAREHOUSE_ID
, MP.ORGANIZATION_CODE
, SPL.SHIPPED_QUANTITY
, SPL.CANCELLED_QUANTITY
, SPL.SHIP_TO_SITE_USE_ID
, SPL.SHIP_TO_CONTACT_ID
, SPL.SHIPMENT_PRIORITY_CODE
, SPL.SHIP_METHOD_CODE
, SPL.DATE_CONFIRMED
, SPL.RA_INTERFACE_STATUS
, SPL.INVOICED_QUANTITY
, SPL.INVENTORY_STATUS
, SPL.UNIT_CODE
, MSI.PRIMARY_UOM_CODE
, SPL.CONTEXT
, SPL.ATTRIBUTE1
, SPL.ATTRIBUTE2
, SPL.ATTRIBUTE3
, SPL.ATTRIBUTE4
, SPL.ATTRIBUTE5
, SPL.ATTRIBUTE6
, SPL.ATTRIBUTE7
, SPL.ATTRIBUTE8
, SPL.ATTRIBUTE9
, SPL.ATTRIBUTE10
, SPL.ATTRIBUTE11
, SPL.ATTRIBUTE12
, SPL.ATTRIBUTE13
, SPL.ATTRIBUTE14
, SPL.ATTRIBUTE15
, SPL.SCHEDULE_DATE
, SPL.DEMAND_CLASS_CODE
, SPL.COMPONENT_SEQUENCE_ID
, SPL.CONFIGURATION_ITEM_FLAG
, SPL.LATEST_ACCEPTABLE_DATE
, SPL.MOVEMENT_ID
, SPL.TRANSACTION_HEADER_ID
FROM MTL_PARAMETERS MP
, SO_HEADERS_ALL SOH
, MTL_SYSTEM_ITEMS_VL MSI
, SO_PICKING_HEADERS_ALL SPH
, SO_PICKING_LINES_ALL SPL
WHERE MSI.INVENTORY_ITEM_ID = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = NVL(SPL.WAREHOUSE_ID
, SPH.WAREHOUSE_ID)
AND SPH.PICKING_HEADER_ID = SPL.PICKING_HEADER_ID
AND SOH.HEADER_ID = SPH.ORDER_HEADER_ID
AND MP.ORGANIZATION_ID = SPL.WAREHOUSE_ID