View: SO_PICKING_LINES_OEXORRSO_V

View Text

SELECT PLN.ROWID ROW_ID
, PLN.PICKING_LINE_ID
, PLN.CREATION_DATE
, PLN.CREATED_BY
, PLN.LAST_UPDATE_DATE
, PLN.LAST_UPDATED_BY
, PLN.LAST_UPDATE_LOGIN
, PLN.REQUEST_ID
, PLN.PROGRAM_APPLICATION_ID
, PLN.PROGRAM_ID
, NULL RESERVABLE_FLAG
, PLN.PROGRAM_UPDATE_DATE
, PLN.PICKING_HEADER_ID
, PLN.SEQUENCE_NUMBER
, PLN.ORDER_LINE_ID
, LIN.HEADER_ID
, LIN.LINE_ID
, LIN.PARENT_LINE_ID
, LIN.LINK_TO_LINE_ID
, LIN.ORDERED_QUANTITY
, LIN.LINE_NUMBER
, NVL(PLN.ORIGINAL_REQUESTED_QUANTITY
, 0) - NVL(PLN.CANCELLED_QUANTITY
, 0) OPEN_QUANTITY
, OE_QUERY.LINE_NUMBER(LIN.LINE_ID
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, LIN.PARENT_LINE_ID
, LIN.LINE_NUMBER) L_NUMBER
, LIN.ATO_FLAG
, LIN.SHIP_SET_NUMBER
, LIN.LINE_TYPE_CODE
, LIN.ITEM_TYPE_CODE
, LIN.OPTION_FLAG
, LIN.OPEN_FLAG
, LIN.SHIP_MODEL_COMPLETE_FLAG
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, DECODE(LIN.OPTION_FLAG
, 'Y'
, LIN.LINE_NUMBER
, NULL) OPTION_NUMBER
, LIN.PROMISE_DATE
, PLN.COMPONENT_CODE
, PLN.LINE_DETAIL_ID
, PLN.COMPONENT_RATIO
, PLN.REQUESTED_QUANTITY
, PLN.INVENTORY_ITEM_ID
, MTL.DESCRIPTION ITEM_DESCRIPTION
, MTL.SO_TRANSACTIONS_FLAG
, PLN.INCLUDED_ITEM_FLAG
, PLN.DATE_REQUESTED
, PLN.ORIGINAL_REQUESTED_QUANTITY
, PLN.WAREHOUSE_ID
, MTLP.ORGANIZATION_CODE WAREHOUSE
, NVL(PLN.SHIPPED_QUANTITY
, 0) SHIPPED_QUANTITY
, NVL(PLN.CANCELLED_QUANTITY
, 0) CANCELLED_QUANTITY
, PLN.SHIP_TO_SITE_USE_ID
, RSU.LOCATION SHIP_TO_LOCATION
, RAD.CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SOH.CUSTOMER_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, SOH.CURRENCY_CODE
, SOH.INVOICE_TO_SITE_USE_ID
, SOH.ORDER_NUMBER
, SOH.ORDER_TYPE_ID
, SOH.ORDER_CATEGORY
, SOT.NAME ORDER_TYPE
, PLN.SHIP_TO_CONTACT_ID
, CON.LAST_NAME || DECODE(CON.FIRST_NAME
, NULL
, NULL
, '
, ' || CON.FIRST_NAME) SHIP_TO_CONTACT_NAME
, PLN.SHIPMENT_PRIORITY_CODE
, SOL.MEANING SHIPMENT_PRIORITY
, PLN.SHIP_METHOD_CODE
, PLN.DATE_CONFIRMED
, PLN.RA_INTERFACE_STATUS
, PLN.INVOICED_QUANTITY
, PLN.INVENTORY_STATUS
, PLN.UNIT_CODE
, PLN.CONTEXT
, PLN.ATTRIBUTE1
, PLN.ATTRIBUTE2
, PLN.ATTRIBUTE3
, PLN.ATTRIBUTE4
, PLN.ATTRIBUTE5
, PLN.ATTRIBUTE6
, PLN.ATTRIBUTE7
, PLN.ATTRIBUTE8
, PLN.ATTRIBUTE9
, PLN.ATTRIBUTE10
, PLN.ATTRIBUTE11
, PLN.ATTRIBUTE12
, PLN.ATTRIBUTE13
, PLN.ATTRIBUTE14
, PLN.ATTRIBUTE15
, PLN.SCHEDULE_DATE
, PLN.DEMAND_CLASS_CODE
, PLN.COMPONENT_SEQUENCE_ID
, PLN.CONFIGURATION_ITEM_FLAG
, PLN.LATEST_ACCEPTABLE_DATE
, MTL.ATP_FLAG
, OE_QUERY.P_LINE_RELEASED_QUANTITY(PLN.PICKING_LINE_ID) RELEASED_QUANTITY
, NVL(DECODE(LIN.PARENT_LINE_ID
, NULL
, MTL.ATP_FLAG
, DECODE(MTL.ATP_FLAG
, 'N'
, MTL.ATP_FLAG
, DECODE(BIC.CHECK_ATP
, '1'
, 'Y'
, 'N')))
, 'N' ) ATP
, OE_QUERY.LINE_TOTAL(LIN.ROWID
, LIN.LINE_ID
, LIN.LINE_TYPE_CODE
, LIN.ITEM_TYPE_CODE
, LIN.SERVICE_DURATION
, NVL(MTL.SERVICEABLE_PRODUCT_FLAG
, 'N' )
, LIN.ORDERED_QUANTITY
, LIN.CANCELLED_QUANTITY
, LIN.SELLING_PRICE) TOTAL_AMOUNT
, OE_QUERY.PICKING_LINE_RESERVED_QTY( PLN.PICKING_LINE_ID) RESERVED_QUANTITY
, OE_QUERY.SHIPMENT_NUMBER(LIN.LINE_ID
, LIN.PARENT_LINE_ID
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, LIN.LINE_NUMBER) SHIPMENT_NUMBER
, OE_QUERY.P_LINE_SCHEDULE_STATUS_CODE(PLN.PICKING_LINE_ID) SCHEDULE_STATUS_CODE
, SO3.MEANING SCHEDULE_STATUS
, PLN.DEP_PLAN_REQUIRED_FLAG
, PLN.CUSTOMER_ITEM_ID
FROM SO_LOOKUPS SOL
, SO_LOOKUPS SO3
, RA_CONTACTS CON
, RA_SITE_USES RSU
, RA_ADDRESSES RAD
, MTL_PARAMETERS MTLP
, MTL_SYSTEM_ITEMS_VL MTL
, RA_CUSTOMERS RAC
, SO_ORDER_TYPES SOT
, BOM_INVENTORY_COMPONENTS BIC
, SO_HEADERS SOH
, SO_LINES LIN
, SO_PICKING_LINES PLN
WHERE PLN.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID (+)
AND NVL(PLN.WAREHOUSE_ID
, TO_NUMBER(FND_PROFILE.VALUE( 'SO_ORGANIZATION_ID'))) = MTL.ORGANIZATION_ID(+)
AND PLN.WAREHOUSE_ID = MTLP.ORGANIZATION_ID (+)
AND PLN.SHIP_TO_SITE_USE_ID = RSU.SITE_USE_ID (+)
AND RAD.ADDRESS_ID (+) = RSU.ADDRESS_ID
AND PLN.SHIP_TO_CONTACT_ID = CON.CONTACT_ID (+)
AND PLN.SHIPMENT_PRIORITY_CODE = SOL.LOOKUP_CODE(+)
AND SOL.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND PLN.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID (+)
AND RAC.CUSTOMER_ID (+) = SOH.CUSTOMER_ID
AND SOH.ORDER_TYPE_ID = SOT.ORDER_TYPE_ID (+)
AND SO3.LOOKUP_TYPE(+) = 'SCHEDULE STATUS'
AND SO3.LOOKUP_CODE(+) = OE_QUERY.P_LINE_SCHEDULE_STATUS_CODE(PLN.PICKING_LINE_ID)
AND SOH.HEADER_ID = LIN.HEADER_ID
AND PLN.PICKING_HEADER_ID = 0
AND LIN.LINE_ID = PLN.ORDER_LINE_ID

Columns