View: OKE_BILLABLE_DELIVERABLES_V

Product:	OKE - Project Contracts
Description:	View for contract deliverables eligible for billing
Implementation/DBA Data:	APPS.OKE_BILLABLE_DELIVERABLES_V

View Text

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

Columns