View: OKE_K_DELIVERABLES_VLH

Product:	OKE - Project Contracts
Description:	Contract deliverable infomation history view
Implementation/DBA Data:	APPS.OKE_K_DELIVERABLES_VLH

View Text

SELECT B.ROWID
, B.DELIVERABLE_ID
, B.DELIVERABLE_NUM
, B.PROJECT_ID
, B.TASK_ID
, P.SEGMENT1
, P.NAME
, TSK.TASK_NAME
, TSK.TASK_NUMBER
, TSK.DESCRIPTION
, B.ITEM_ID
, B.K_HEADER_ID
, B.K_LINE_ID
, B.DELIVERY_DATE
, B.STATUS_CODE
, B.PARENT_DELIVERABLE_ID
, B.DIRECTION
, B.SHIP_TO_ORG_ID
, B.SHIP_TO_LOCATION_ID
, B.SHIP_FROM_ORG_ID
, B.SHIP_FROM_LOCATION_ID
, B.INVENTORY_ORG_ID
, B.DEFAULTED_FLAG
, B.IN_PROCESS_FLAG
, B.WF_ITEM_KEY
, B.SUB_REF_ID
, B.START_DATE
, B.END_DATE
, B.NEED_BY_DATE
, B.PRIORITY_CODE
, B.CURRENCY_CODE
, B.UNIT_PRICE
, B.UOM_CODE
, B.QUANTITY
, B.COUNTRY_OF_ORIGIN_CODE
, B.SUBCONTRACTED_FLAG
, B.DEPENDENCY_FLAG
, B.BILLABLE_FLAG
, B.BILLING_EVENT_ID
, B.DROP_SHIPPED_FLAG
, B.COMPLETED_FLAG
, B.AVAILABLE_FOR_SHIP_FLAG
, B.CREATE_DEMAND
, B.READY_TO_BILL
, B.READY_TO_PROCURE
, B.MPS_TRANSACTION_ID
, B.SHIPPING_REQUEST_ID
, B.PO_REF_1
, B.PO_REF_2
, B.PO_REF_3
, B.UNIT_NUMBER
, B.NDB_SCHEDULE_DESIGNATOR
, B.SHIPPABLE_FLAG
, B.CFE_REQ_FLAG
, B.INSPECTION_REQ_FLAG
, B.INTERIM_RPT_REQ_FLAG
, B.LOT_APPLIES_FLAG
, B.CUSTOMER_APPROVAL_REQ_FLAG
, B.EXPECTED_SHIPMENT_DATE
, B.INITIATE_SHIPMENT_DATE
, B.PROMISED_SHIPMENT_DATE
, B.AS_OF_DATE
, B.DATE_OF_FIRST_SUBMISSION
, B.FREQUENCY
, B.ACQ_DOC_NUMBER
, B.SUBMISSION_FLAG
, B.DATA_ITEM_SUBTITLE
, B.TOTAL_NUM_OF_COPIES
, B.CDRL_CATEGORY
, B.DATA_ITEM_NAME
, B.EXPORT_FLAG
, B.EXPORT_LICENSE_NUM
, B.EXPORT_LICENSE_RES
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.DESCRIPTION
, T.COMMENTS
, T.SFWT_FLAG
, ST.MEANING
, B.VOLUME
, B.VOLUME_UOM_CODE
, B.WEIGHT
, B.WEIGHT_UOM_CODE
, B.EXPENDITURE_ORGANIZATION_ID
, B.EXPENDITURE_TYPE
, B.EXPENDITURE_ITEM_DATE
, B.DESTINATION_TYPE_CODE
, B.RATE_TYPE
, B.RATE_DATE
, B.EXCHANGE_RATE
, B.MAJOR_VERSION
FROM OKE_K_DELIVERABLES_BH B
, OKE_K_DELIVERABLES_TLH T
, PA_PROJECTS_ALL P
, PA_TASKS TSK
, OKC_STATUSES_V ST
WHERE B.DELIVERABLE_ID = T.DELIVERABLE_ID
AND B.MAJOR_VERSION = T.MAJOR_VERSION
AND P.PROJECT_ID (+) = B.PROJECT_ID
AND TSK.TASK_ID (+) = B.TASK_ID
AND ST.CODE = B.STATUS_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns