VIEW: APPS.SO_PICKING_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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