VIEW: APPS.ICX_SO_LINES_VIEW_LINES_V

Source

View Text - Preformatted

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 , OEXVWLIN.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 , OEXVWLIN.HOLD(SL.LINE_ID, SL.HEADER_ID) HOLD , NVL(SL.LIST_PRICE, 0)-NVL(SL.SELLING_PRICE, 0) DISCOUNT , to_char(SL.SELLING_PRICE ,fnd_currency.safe_get_format_mask(SH.CURRENCY_CODE,30)) SELLING_PRICE , to_char(SL.LIST_PRICE ,fnd_currency.safe_get_format_mask(SH.CURRENCY_CODE,30)) LIST_PRICE ,to_char( NVL(SL.SELLING_PRICE,0)*( NVL(SL.ORDERED_QUANTITY,0) - NVL(SL.CANCELLED_QUANTITY,0) ) ,fnd_currency.safe_get_format_mask(SH.CURRENCY_CODE,30)) EXTENDED_PRICE , SL.TAX_CODE TAX_CODE ,to_char( OEXVWLIN.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) ) ,fnd_currency.safe_get_format_mask(SH.CURRENCY_CODE,30)) LINE_TOTAL , DECODE(SL.PARENT_LINE_ID,NULL,NULL,SL.LINE_NUMBER) OPTION_NUMBER , OEXVWLIN.SHIPMENT_NUMBER(SL.LINE_ID, SL.PARENT_LINE_ID, SL.SHIPMENT_SCHEDULE_LINE_ID, SL.LINE_NUMBER) SHIPMENT_NUMBER , OEXVWLIN.LINE_NUMBER(SL.LINE_ID, SL.SHIPMENT_SCHEDULE_LINE_ID, SL.PARENT_LINE_ID, SL.LINE_NUMBER) LINE_NUMBER , OEXVWLIN.RESERVED_QUANTITY(SL.LINE_ID) RESERVED_QUANTITY , OEXVWLIN.ITEM_CONC_SEG(SL.INVENTORY_ITEM_ID, FND_PROFILE.VALUE_SPECIFIC('SO_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 , MSI.ATTRIBUTE14 ITEM_URL , sl.project_id , pp.segment1 , sl.task_id , pt.task_number FROM SO_LINES SL, SO_HEADERS SH, MTL_SYSTEM_ITEMS MSI, pa_projects pp, pa_tasks pt WHERE MSI.INVENTORY_ITEM_ID(+) = SL.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID(+) = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID') AND SL.HEADER_ID = SH.HEADER_ID and sl.project_id = pp.project_id (+) and sl.task_id = pt.task_id (+)

View Text - HTML Formatted

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
, OEXVWLIN.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
, OEXVWLIN.HOLD(SL.LINE_ID
, SL.HEADER_ID) HOLD
, NVL(SL.LIST_PRICE
, 0)-NVL(SL.SELLING_PRICE
, 0) DISCOUNT
, TO_CHAR(SL.SELLING_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SH.CURRENCY_CODE
, 30)) SELLING_PRICE
, TO_CHAR(SL.LIST_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SH.CURRENCY_CODE
, 30)) LIST_PRICE
, TO_CHAR( NVL(SL.SELLING_PRICE
, 0)*( NVL(SL.ORDERED_QUANTITY
, 0) - NVL(SL.CANCELLED_QUANTITY
, 0) )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SH.CURRENCY_CODE
, 30)) EXTENDED_PRICE
, SL.TAX_CODE TAX_CODE
, TO_CHAR( OEXVWLIN.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) )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SH.CURRENCY_CODE
, 30)) LINE_TOTAL
, DECODE(SL.PARENT_LINE_ID
, NULL
, NULL
, SL.LINE_NUMBER) OPTION_NUMBER
, OEXVWLIN.SHIPMENT_NUMBER(SL.LINE_ID
, SL.PARENT_LINE_ID
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.LINE_NUMBER) SHIPMENT_NUMBER
, OEXVWLIN.LINE_NUMBER(SL.LINE_ID
, SL.SHIPMENT_SCHEDULE_LINE_ID
, SL.PARENT_LINE_ID
, SL.LINE_NUMBER) LINE_NUMBER
, OEXVWLIN.RESERVED_QUANTITY(SL.LINE_ID) RESERVED_QUANTITY
, OEXVWLIN.ITEM_CONC_SEG(SL.INVENTORY_ITEM_ID
, FND_PROFILE.VALUE_SPECIFIC('SO_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
, MSI.ATTRIBUTE14 ITEM_URL
, SL.PROJECT_ID
, PP.SEGMENT1
, SL.TASK_ID
, PT.TASK_NUMBER
FROM SO_LINES SL
, SO_HEADERS SH
, MTL_SYSTEM_ITEMS MSI
, PA_PROJECTS PP
, PA_TASKS PT
WHERE MSI.INVENTORY_ITEM_ID(+) = SL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID')
AND SL.HEADER_ID = SH.HEADER_ID
AND SL.PROJECT_ID = PP.PROJECT_ID (+)
AND SL.TASK_ID = PT.TASK_ID (+)