VIEW: APPS.SO_PICKING_LINE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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