VIEW: APPS.OKE_BILLABLE_DELIVERABLES_V

Source

View Text - Preformatted

SELECT D.ROWID , D.K_HEADER_ID , D.K_LINE_ID , L.LINE_NUMBER , D.DELIVERABLE_ID , D.DELIVERABLE_NUM , D.PROJECT_ID , D.TASK_ID , D.INVENTORY_ORG_ID , O.ORGANIZATION_CODE , D.ITEM_ID , I.ITEM_NUMBER , D.DELIVERY_DATE , D.QUANTITY , ( SELECT SUM( DECODE( REQUESTED_QUANTITY_UOM , NULL , NVL(SHIPPED_QUANTITY , 0) , D.UOM_CODE , NVL(SHIPPED_QUANTITY , 0) , INV_CONVERT.INV_UM_CONVERT ( INVENTORY_ITEM_ID , 5 , NVL(SHIPPED_QUANTITY , 0) , REQUESTED_QUANTITY_UOM , D.UOM_CODE , NULL , NULL ) ) ) FROM WSH_DELIVERY_DETAILS WHERE SOURCE_CODE = 'OKE' AND SOURCE_HEADER_ID = D.K_HEADER_ID AND SOURCE_LINE_ID = D.DELIVERABLE_ID ) SHIPPED_QUANTITY , D.UOM_CODE , D.UNIT_PRICE , D.CURRENCY_CODE FROM OKE_K_DELIVERABLES_B D , OKC_K_LINES_B L , MTL_PARAMETERS O , MTL_ITEM_FLEXFIELDS I WHERE D.BILLABLE_FLAG = 'Y' AND D.READY_TO_BILL = 'Y' AND L.ID = D.K_LINE_ID AND O.ORGANIZATION_ID (+) = D.INVENTORY_ORG_ID AND I.INVENTORY_ITEM_ID (+) = D.ITEM_ID AND I.ORGANIZATION_ID (+) = D.INVENTORY_ORG_ID

View Text - HTML Formatted

SELECT D.ROWID
, D.K_HEADER_ID
, D.K_LINE_ID
, L.LINE_NUMBER
, D.DELIVERABLE_ID
, D.DELIVERABLE_NUM
, D.PROJECT_ID
, D.TASK_ID
, D.INVENTORY_ORG_ID
, O.ORGANIZATION_CODE
, D.ITEM_ID
, I.ITEM_NUMBER
, D.DELIVERY_DATE
, D.QUANTITY
, ( SELECT SUM( DECODE( REQUESTED_QUANTITY_UOM
, NULL
, NVL(SHIPPED_QUANTITY
, 0)
, D.UOM_CODE
, NVL(SHIPPED_QUANTITY
, 0)
, INV_CONVERT.INV_UM_CONVERT ( INVENTORY_ITEM_ID
, 5
, NVL(SHIPPED_QUANTITY
, 0)
, REQUESTED_QUANTITY_UOM
, D.UOM_CODE
, NULL
, NULL ) ) )
FROM WSH_DELIVERY_DETAILS
WHERE SOURCE_CODE = 'OKE'
AND SOURCE_HEADER_ID = D.K_HEADER_ID
AND SOURCE_LINE_ID = D.DELIVERABLE_ID ) SHIPPED_QUANTITY
, D.UOM_CODE
, D.UNIT_PRICE
, D.CURRENCY_CODE
FROM OKE_K_DELIVERABLES_B D
, OKC_K_LINES_B L
, MTL_PARAMETERS O
, MTL_ITEM_FLEXFIELDS I
WHERE D.BILLABLE_FLAG = 'Y'
AND D.READY_TO_BILL = 'Y'
AND L.ID = D.K_LINE_ID
AND O.ORGANIZATION_ID (+) = D.INVENTORY_ORG_ID
AND I.INVENTORY_ITEM_ID (+) = D.ITEM_ID
AND I.ORGANIZATION_ID (+) = D.INVENTORY_ORG_ID