VIEW: APPS.OKE_K_DELIVERABLES_VLH

Source

View Text - Preformatted

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.REQUISITION_LINE_TYPE_ID , B.PO_CATEGORY_ID , 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')

View Text - HTML Formatted

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.REQUISITION_LINE_TYPE_ID
, B.PO_CATEGORY_ID
, 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')