View: SO_LINES_VIEW_LINES_V

View Text

SELECT SL.LINE_ID LINE_ID
, SL.HEADER_ID HEADER_ID
, SL.ORDERED_QUANTITY ORDERED_QUANTITY
, SL.CANCELLED_QUANTITY CANCELLED_QUANTITY
, NVL(SL.ORDERED_QUANTITY
, 0)- NVL(SL.CANCELLED_QUANTITY
, 0) OPEN_QUANTITY
, OE_QUERY.SCHEDULE_STATUS(SL.LINE_ID) SCHEDULE_STATUS
, SL.UNIT_CODE UNIT_CODE
, SL.SHIPPED_QUANTITY SHIPPED_QUANTITY
, SL.SCHEDULE_DATE SCHEDULE_DATE
, SL.DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT
, SL.PROMISE_DATE PROMISE_DATE
, SL.SHIP_SET_NUMBER SHIP_SET_NUMBER
, OE_QUERY.HOLD(SL.LINE_ID
, SL.HEADER_ID) HOLD
, NVL(SL.LIST_PRICE
, 0)- NVL(SL.SELLING_PRICE
, 0) DISCOUNT
, SL.SELLING_PRICE SELLING_PRICE
, SL.LIST_PRICE LIST_PRICE
, NVL(SL.SELLING_PRICE
, 0)*(NVL(SL.ORDERED_QUANTITY
, 0) - NVL(SL.CANCELLED_QUANTITY
, 0) ) EXTENDED_PRICE
, SL.TAX_CODE TAX_CODE
, OE_QUERY.LINE_TOTAL(SL.ROWID
, SL.LINE_ID
, SL.LINE_TYPE_CODE
, SL.ITEM_TYPE_CODE
, SL.SERVICE_DURATION
, NVL(MSI.SERVICEABLE_PRODUCT_FLAG
, 'N')
, NVL(SL.ORDERED_QUANTITY
, 0)
, NVL(SL.CANCELLED_QUANTITY
, 0)
, NVL(SL.SELLING_PRICE
, 0) ) LINE_TOTAL
, OE_QUERY.OPTION_LINE_NUMBER (SL.PARENT_LINE_ID
, SL.SERVICE_PARENT_LINE_ID
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.LINE_NUMBER) OPTION_NUMBER
, OE_QUERY.SHIPMENT_SCHEDULE_NUMBER(SL.PARENT_LINE_ID
, SL.SERVICE_PARENT_LINE_ID
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.LINE_NUMBER) SHIPMENT_NUMBER
, OE_QUERY.BASE_LINE_NUMBER( SL.PARENT_LINE_ID
, SL.SERVICE_PARENT_LINE_ID
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.LINE_NUMBER) LINE_NUMBER
, OE_QUERY.RESERVED_QUANTITY(SL.LINE_ID) RESERVED_QUANTITY
, OE_QUERY.ITEM_CONC_SEG(SL.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID) ITEM
, NVL(MSI.DESCRIPTION
, 'NO DESCRIPTION AVAILABLE') ITEM_DESC
, SL.LINE_TYPE_CODE LINE_TYPE_CODE
, SL.SERVICE_PARENT_LINE_ID SERVICE_PARENT_LINE_ID
, SL.PARENT_LINE_ID PARENT_LINE_ID
, SL.ORIGINAL_SYSTEM_LINE_REFERENCE
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1
, SL.PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2
, SL.PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3
, SL.PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4
, SL.PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5
, SL.PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6
, SL.PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7
, SL.PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8
, SL.PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9
, SL.PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10
, SL.PRICING_ATTRIBUTE11 PRICING_ATTRIBUTE11
, SL.PRICING_ATTRIBUTE12 PRICING_ATTRIBUTE12
, SL.PRICING_ATTRIBUTE13 PRICING_ATTRIBUTE13
, SL.PRICING_ATTRIBUTE14 PRICING_ATTRIBUTE14
, SL.PRICING_ATTRIBUTE15 PRICING_ATTRIBUTE15
, SL.PRICING_CONTEXT PRICING_CONTEXT
, SL.ATTRIBUTE1 ATTRIBUTE1
, SL.ATTRIBUTE2 ATTRIBUTE2
, SL.ATTRIBUTE3 ATTRIBUTE3
, SL.ATTRIBUTE4 ATTRIBUTE4
, SL.ATTRIBUTE5 ATTRIBUTE5
, SL.ATTRIBUTE6 ATTRIBUTE6
, SL.ATTRIBUTE7 ATTRIBUTE7
, SL.ATTRIBUTE8 ATTRIBUTE8
, SL.ATTRIBUTE9 ATTRIBUTE9
, SL.ATTRIBUTE10 ATTRIBUTE10
, SL.ATTRIBUTE11 ATTRIBUTE11
, SL.ATTRIBUTE12 ATTRIBUTE12
, SL.ATTRIBUTE13 ATTRIBUTE13
, SL.ATTRIBUTE14 ATTRIBUTE14
, SL.ATTRIBUTE15 ATTRIBUTE15
, SL.CONTEXT CONTEXT
, 0 DUMMY_ID
, OE_QUERY.LINE_RELEASED_QTY(SL.LINE_ID) RELEASED_QUANTITY
, SL.INVENTORY_ITEM_ID
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, SL.LAST_UPDATE_LOGIN
, SL.REQUEST_ID
, SL.PROGRAM_APPLICATION_ID
, SL.PROGRAM_ID
, SL.PROGRAM_UPDATE_DATE
, SL.SHIP_TO_SITE_USE_ID
, SL.ROWID ROW_ID
, SL.OPEN_FLAG
, SL.ITEM_TYPE_CODE ITEM_TYPE_CODE
, SL.TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, MTLPRT.ORGANIZATION_CODE WAREHOUSE_CODE
, SL.CUSTOMER_ITEM_ID
, MCI.CUSTOMER_ITEM_NUMBER
, SL.INTERMEDIATE_SHIP_TO_ID
, SL.CUSTOMER_JOB
, SL.CUSTOMER_PRODUCTION_LINE
, SL.CUSTOMER_MODEL_SERIAL_NUMBER
, SL.PLANNING_PROD_SEQ_NUMBER
, SL.CUSTOMER_DOCK_CODE
, RSU.LOCATION INTERMEDIATE_SHIP_TO_LOCATION
, DECODE(SL.SERVICE_PARENT_LINE_ID
, NULL
, NULL
, SL.LINE_NUMBER) SERVICE_LINE_NUMBER
, SL.SERVICE_DURATION SERVICE_DURATION
, SLKP.MEANING SOURCE_TYPE
, SL.PLANNING_PRIORITY
, SL.END_ITEM_UNIT_NUMBER
FROM SO_LINES SL
, SO_LOOKUPS SLKP
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_PARAMETERS MTLPRT
, MTL_CUSTOMER_ITEMS MCI
, RA_SITE_USES RSU
WHERE MSI.INVENTORY_ITEM_ID = SL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID')
AND MTLPRT.ORGANIZATION_ID(+) = SL.WAREHOUSE_ID
AND SL.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID (+)
AND SL.INTERMEDIATE_SHIP_TO_ID = RSU.SITE_USE_ID (+)
AND SLKP.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND SLKP.LOOKUP_CODE(+) = SL.SOURCE_TYPE_CODE

Columns