View: WSHFV_PICK_LINE_DETAIL

View Text

SELECT PLD.LAST_UPDATE_DATE
, PLD.LAST_UPDATED_BY
, PLD.LAST_UPDATE_LOGIN
, PLD.PICKING_LINE_DETAIL_ID
, PLD.PICKING_LINE_ID
, PLD.WAREHOUSE_ID ORGANIZATION_ID
, ORG.ORGANIZATION_CODE WAREHOUSE_CODE
, H_ORG.NAME ORG_NAME
, PLD.REQUESTED_QUANTITY
, PLD.SHIPPED_QUANTITY
, PLD.SERIAL_NUMBER
, PLD.LOT_NUMBER
, PLD.CUSTOMER_REQUESTED_LOT_FLAG
, PLD.REVISION
, PLD.SUBINVENTORY
, PLD.INVENTORY_LOCATION_ID
, PLD.INVENTORY_LOCATION_SEGMENTS
, PLD.DETAIL_TYPE_CODE
, PLD.RELEASED_FLAG
, PLD.SCHEDULE_DATE
, PLD.DEMAND_ID
, PLD.AUTOSCHEDULED_FLAG
, PLD.DELIVERY
, PLD.RESERVABLE_FLAG
, PLD.TRANSACTABLE_FLAG
, PLD.LATEST_ACCEPTABLE_DATE
, PLD.DEPARTURE_ID
, WDP.NAME DEPARTURE_NAME
, PLD.DELIVERY_ID
, PLD.CONTAINER_ID
, PC.CONTAINER_INVENTORY_ITEM_ID
, MSI2.DESCRIPTION CONTAINER_DESCRIPTION
, PLD.MASTER_CONTAINER_ITEM_ID
, PLD.DETAIL_CONTAINER_ITEM_ID
, PLD.LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, PLD.TRANSACTION_TEMP_ID
, PLD.SCHEDULE_LEVEL
, PLD.SCHEDULE_STATUS_CODE
, PLD.WIP_RESERVED_QUANTITY
, PLD.WIP_COMPLETED_QUANTITY
, PLD.SUPPLY_SOURCE_TYPE
, PLD.SUPPLY_SOURCE_HEADER_ID
, PLD.UPDATE_FLAG
, PLD.DEMAND_CLASS_CODE
, PL.DEP_PLAN_REQUIRED_FLAG
, PL.CUSTOMER_ITEM_ID
, PLD.DPW_ASSIGNED_FLAG
, PL.ROWID PL_ROW_ID
, DECODE(PL.BO_PICKING_LINE_ID
, ''
, SL.SHIP_SET_NUMBER
, NULL) BO_PICKING_LINE_ID
, PLD.PICK_SLIP_NUMBER
, PL.ORIGINAL_REQUESTED_QUANTITY
, PL.REQUESTED_QUANTITY PL_REQUESTED_QUANTITY
, PL.SHIPPED_QUANTITY PL_SHIPPED_QUANTITY
, PL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI1.DESCRIPTION ITEM_DESCRIPTION
, DECODE(MSI1.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') SUBINV_RESTRICTED_FLAG
, DECODE(MSI1.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N') REVISION_CONTROL_FLAG
, DECODE(MSI1.LOT_CONTROL_CODE
, 2
, 'Y'
, 'N') LOT_CONTROL_FLAG
, DECODE(MSI1.SERIAL_NUMBER_CONTROL_CODE
, 2
, 'Y'
, 5
, 'Y'
, 6
, DECODE(SH.ORDER_CATEGORY
, 'P'
, 'N'
, 'Y')
, 'N') SERIAL_NUMBER_CONTROL_FLAG
, MSI1.SERIAL_NUMBER_CONTROL_CODE
, MSI1.RESTRICT_LOCATORS_CODE
, ORG.STOCK_LOCATOR_CONTROL_CODE ORG_LOCATION_CONTROL_CODE
, ORG.NEGATIVE_INV_RECEIPT_CODE
, MSI1.LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE
, PL.INCLUDED_ITEM_FLAG
, DECODE(MSI1.RESERVABLE_TYPE
, 1
, 'Y'
, 'N') ITEM_RESERVABLE_FLAG
, MSI1.PRIMARY_UOM_CODE
, PL.CONFIGURATION_ITEM_FLAG
, PL.PICKING_HEADER_ID
, PL.ORDER_LINE_ID
, PL.LINE_DETAIL_ID
, NVL(PL.SHIP_TO_SITE_USE_ID
, SH.SHIP_TO_SITE_USE_ID) SHIP_TO_SITE_USE_ID
, SU1.LOCATION ULTIMATE_SHIP_TO
, PL.SHIP_TO_CONTACT_ID
, PL.SHIPMENT_PRIORITY_CODE
, NVL(PL.SHIP_METHOD_CODE
, SH.SHIP_METHOD_CODE) SHIP_METHOD_CODE
, PL.UNIT_CODE
, PL.DATE_REQUESTED
, PL.DATE_CONFIRMED PL_DATE_CONFIRMED
, PL.SEQUENCE_NUMBER PL_SEQUENCE_NUMBER
, DEL.NAME DELIVERY_NAME
, DEL.STATUS_CODE DEL_STATUS_CODE
, DEL.SOURCE_CODE DEL_SOURCE_CODE
, PH.STATUS_CODE PH_STATUS
, PH.ORDER_HEADER_ID
, PH.BATCH_ID
, PB.NAME BATCH_NAME
, PH.DATE_RELEASED
, SH.ORDER_NUMBER ORDER_NUMBER
, SH.CUSTOMER_ID CUSTOMER_ID
, SH.ORDER_CATEGORY
, RC.CUSTOMER_NAME CUSTOMER_NAME
, RC.CUSTOMER_NUMBER CUSTOMER_NUMBER
, SH.FREIGHT_TERMS_CODE
, SH.FOB_CODE
, SH.CURRENCY_CODE
, SL.INTERMEDIATE_SHIP_TO_ID
, SU2.LOCATION INTERMEDIATE_SHIP_TO
, SL.ATO_FLAG
, SL.LINE_NUMBER
, SL.PARENT_LINE_ID
, SL.LINK_TO_LINE_ID
, SL.CUSTOMER_JOB
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.CUSTOMER_DOCK_CODE
, SL.CUSTOMER_PRODUCTION_LINE
, SL.ITEM_TYPE_CODE
, PC.SEQUENCE_NUMBER PC_SEQUENCE_NUMBER
, MTF.ITEM_NUMBER
, PLD.MOVEMENT_ID
FROM SO_PICKING_LINE_DETAILS PLD
, MTL_PARAMETERS ORG
, HR_ALL_ORGANIZATION_UNITS H_ORG
, SO_PICKING_LINES_ALL PL
, WSH_DELIVERIES DEL
, SO_HEADERS_ALL SH
, RA_CUSTOMERS RC
, SO_PICKING_BATCHES_ALL PB
, SO_PICKING_HEADERS_ALL PH
, SO_LINES_ALL SL
, RA_SITE_USES_ALL SU1
, RA_SITE_USES_ALL SU2
, MTL_SYSTEM_ITEMS MSI1
, WSH_PACKED_CONTAINERS PC
, MTL_ITEM_FLEXFIELDS MTF
, MTL_SYSTEM_ITEMS MSI2
, WSH_DEPARTURES WDP
WHERE PLD.PICKING_LINE_ID = PL.PICKING_LINE_ID
AND PH.PICKING_HEADER_ID = PL.PICKING_HEADER_ID
AND PH.BATCH_ID = PB.BATCH_ID
AND PH.ORDER_HEADER_ID = SH.HEADER_ID
AND RC.CUSTOMER_ID = SH.CUSTOMER_ID
AND ORG.ORGANIZATION_ID = PLD.WAREHOUSE_ID
AND H_ORG.ORGANIZATION_ID = PLD.WAREHOUSE_ID
AND PL.ORDER_LINE_ID = SL.LINE_ID
AND SU1.SITE_USE_ID(+) = PL.SHIP_TO_SITE_USE_ID
AND SU2.SITE_USE_ID (+) = SL.INTERMEDIATE_SHIP_TO_ID
AND PL.INVENTORY_ITEM_ID = MSI1.INVENTORY_ITEM_ID (+)
AND PLD.WAREHOUSE_ID = MSI1.ORGANIZATION_ID
AND PLD.CONTAINER_ID = PC.CONTAINER_ID (+)
AND PC.CONTAINER_INVENTORY_ITEM_ID = MSI2.INVENTORY_ITEM_ID (+)
AND PC.ORGANIZATION_ID = MSI2.ORGANIZATION_ID (+)
AND DEL.DELIVERY_ID(+) = PLD.DELIVERY_ID
AND PC.CONTAINER_INVENTORY_ITEM_ID = MTF.INVENTORY_ITEM_ID (+)
AND PC.ORGANIZATION_ID = MTF.ORGANIZATION_ID (+)
AND WDP.DEPARTURE_ID (+) = PLD.DEPARTURE_ID

Columns