VIEW: OKE.OKE_K_DELIVERABLES_B#

Source

View Text - Preformatted

select DELIVERABLE_ID DELIVERABLE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DELIVERABLE_NUM DELIVERABLE_NUM, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ITEM_ID ITEM_ID, K_HEADER_ID K_HEADER_ID, K_LINE_ID K_LINE_ID, DELIVERY_DATE DELIVERY_DATE, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, PARENT_DELIVERABLE_ID PARENT_DELIVERABLE_ID, DIRECTION DIRECTION, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, INVENTORY_ORG_ID INVENTORY_ORG_ID, DEFAULTED_FLAG DEFAULTED_FLAG, IN_PROCESS_FLAG IN_PROCESS_FLAG, WF_ITEM_KEY WF_ITEM_KEY, SUB_REF_ID SUB_REF_ID, START_DATE START_DATE, END_DATE END_DATE, NEED_BY_DATE NEED_BY_DATE, PRIORITY_CODE PRIORITY_CODE, CURRENCY_CODE CURRENCY_CODE, UNIT_PRICE UNIT_PRICE, UOM_CODE UOM_CODE, QUANTITY QUANTITY, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, SUBCONTRACTED_FLAG SUBCONTRACTED_FLAG, DEPENDENCY_FLAG DEPENDENCY_FLAG, BILLABLE_FLAG BILLABLE_FLAG, DROP_SHIPPED_FLAG DROP_SHIPPED_FLAG, COMPLETED_FLAG COMPLETED_FLAG, AVAILABLE_FOR_SHIP_FLAG AVAILABLE_FOR_SHIP_FLAG, CREATE_DEMAND CREATE_DEMAND, READY_TO_BILL READY_TO_BILL, READY_TO_PROCURE READY_TO_PROCURE, SHIPPABLE_FLAG SHIPPABLE_FLAG, CFE_REQ_FLAG CFE_REQ_FLAG, INSPECTION_REQ_FLAG INSPECTION_REQ_FLAG, INTERIM_RPT_REQ_FLAG INTERIM_RPT_REQ_FLAG, LOT_APPLIES_FLAG LOT_APPLIES_FLAG, CUSTOMER_APPROVAL_REQ_FLAG CUSTOMER_APPROVAL_REQ_FLAG, EXPECTED_SHIPMENT_DATE EXPECTED_SHIPMENT_DATE, INITIATE_SHIPMENT_DATE INITIATE_SHIPMENT_DATE, PROMISED_SHIPMENT_DATE PROMISED_SHIPMENT_DATE, AS_OF_DATE AS_OF_DATE, DATE_OF_FIRST_SUBMISSION DATE_OF_FIRST_SUBMISSION, FREQUENCY FREQUENCY, ACQ_DOC_NUMBER ACQ_DOC_NUMBER, SUBMISSION_FLAG SUBMISSION_FLAG, DATA_ITEM_SUBTITLE DATA_ITEM_SUBTITLE, TOTAL_NUM_OF_COPIES TOTAL_NUM_OF_COPIES, CDRL_CATEGORY CDRL_CATEGORY, DATA_ITEM_NAME DATA_ITEM_NAME, EXPORT_FLAG EXPORT_FLAG, EXPORT_LICENSE_NUM EXPORT_LICENSE_NUM, EXPORT_LICENSE_RES EXPORT_LICENSE_RES, SHIPPING_REQUEST_ID SHIPPING_REQUEST_ID, MPS_TRANSACTION_ID MPS_TRANSACTION_ID, PO_REF_1 PO_REF_1, PO_REF_2 PO_REF_2, PO_REF_3 PO_REF_3, UNIT_NUMBER UNIT_NUMBER, NDB_SCHEDULE_DESIGNATOR NDB_SCHEDULE_DESIGNATOR, BILLING_EVENT_ID BILLING_EVENT_ID, BILL_EVENT_TYPE BILL_EVENT_TYPE, BILL_EVENT_DATE BILL_EVENT_DATE, BILL_ITEM_ID BILL_ITEM_ID, BILL_LINE_ID BILL_LINE_ID, BILL_CHG_REQ_ID BILL_CHG_REQ_ID, BILL_PROJECT_ID BILL_PROJECT_ID, BILL_TASK_ID BILL_TASK_ID, BILL_ORGANIZATION_ID BILL_ORGANIZATION_ID, BILL_FUND_REF1 BILL_FUND_REF1, BILL_FUND_REF2 BILL_FUND_REF2, BILL_FUND_REF3 BILL_FUND_REF3, BILL_BILL_OF_LADING BILL_BILL_OF_LADING, BILL_SERIAL_NUM BILL_SERIAL_NUM, BILL_CURRENCY_CODE BILL_CURRENCY_CODE, BILL_RATE_TYPE BILL_RATE_TYPE, BILL_RATE_DATE BILL_RATE_DATE, BILL_EXCHANGE_RATE BILL_EXCHANGE_RATE, BILL_DESCRIPTION BILL_DESCRIPTION, BILL_QUANTITY BILL_QUANTITY, BILL_UNIT_PRICE BILL_UNIT_PRICE, REVENUE_AMOUNT REVENUE_AMOUNT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, WEIGHT WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, REQUISITION_LINE_TYPE_ID REQUISITION_LINE_TYPE_ID, PO_CATEGORY_ID PO_CATEGORY_ID from "OKE"."OKE_K_DELIVERABLES_B"

View Text - HTML Formatted

SELECT DELIVERABLE_ID DELIVERABLE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DELIVERABLE_NUM DELIVERABLE_NUM
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ITEM_ID ITEM_ID
, K_HEADER_ID K_HEADER_ID
, K_LINE_ID K_LINE_ID
, DELIVERY_DATE DELIVERY_DATE
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, PARENT_DELIVERABLE_ID PARENT_DELIVERABLE_ID
, DIRECTION DIRECTION
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, INVENTORY_ORG_ID INVENTORY_ORG_ID
, DEFAULTED_FLAG DEFAULTED_FLAG
, IN_PROCESS_FLAG IN_PROCESS_FLAG
, WF_ITEM_KEY WF_ITEM_KEY
, SUB_REF_ID SUB_REF_ID
, START_DATE START_DATE
, END_DATE END_DATE
, NEED_BY_DATE NEED_BY_DATE
, PRIORITY_CODE PRIORITY_CODE
, CURRENCY_CODE CURRENCY_CODE
, UNIT_PRICE UNIT_PRICE
, UOM_CODE UOM_CODE
, QUANTITY QUANTITY
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, SUBCONTRACTED_FLAG SUBCONTRACTED_FLAG
, DEPENDENCY_FLAG DEPENDENCY_FLAG
, BILLABLE_FLAG BILLABLE_FLAG
, DROP_SHIPPED_FLAG DROP_SHIPPED_FLAG
, COMPLETED_FLAG COMPLETED_FLAG
, AVAILABLE_FOR_SHIP_FLAG AVAILABLE_FOR_SHIP_FLAG
, CREATE_DEMAND CREATE_DEMAND
, READY_TO_BILL READY_TO_BILL
, READY_TO_PROCURE READY_TO_PROCURE
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, CFE_REQ_FLAG CFE_REQ_FLAG
, INSPECTION_REQ_FLAG INSPECTION_REQ_FLAG
, INTERIM_RPT_REQ_FLAG INTERIM_RPT_REQ_FLAG
, LOT_APPLIES_FLAG LOT_APPLIES_FLAG
, CUSTOMER_APPROVAL_REQ_FLAG CUSTOMER_APPROVAL_REQ_FLAG
, EXPECTED_SHIPMENT_DATE EXPECTED_SHIPMENT_DATE
, INITIATE_SHIPMENT_DATE INITIATE_SHIPMENT_DATE
, PROMISED_SHIPMENT_DATE PROMISED_SHIPMENT_DATE
, AS_OF_DATE AS_OF_DATE
, DATE_OF_FIRST_SUBMISSION DATE_OF_FIRST_SUBMISSION
, FREQUENCY FREQUENCY
, ACQ_DOC_NUMBER ACQ_DOC_NUMBER
, SUBMISSION_FLAG SUBMISSION_FLAG
, DATA_ITEM_SUBTITLE DATA_ITEM_SUBTITLE
, TOTAL_NUM_OF_COPIES TOTAL_NUM_OF_COPIES
, CDRL_CATEGORY CDRL_CATEGORY
, DATA_ITEM_NAME DATA_ITEM_NAME
, EXPORT_FLAG EXPORT_FLAG
, EXPORT_LICENSE_NUM EXPORT_LICENSE_NUM
, EXPORT_LICENSE_RES EXPORT_LICENSE_RES
, SHIPPING_REQUEST_ID SHIPPING_REQUEST_ID
, MPS_TRANSACTION_ID MPS_TRANSACTION_ID
, PO_REF_1 PO_REF_1
, PO_REF_2 PO_REF_2
, PO_REF_3 PO_REF_3
, UNIT_NUMBER UNIT_NUMBER
, NDB_SCHEDULE_DESIGNATOR NDB_SCHEDULE_DESIGNATOR
, BILLING_EVENT_ID BILLING_EVENT_ID
, BILL_EVENT_TYPE BILL_EVENT_TYPE
, BILL_EVENT_DATE BILL_EVENT_DATE
, BILL_ITEM_ID BILL_ITEM_ID
, BILL_LINE_ID BILL_LINE_ID
, BILL_CHG_REQ_ID BILL_CHG_REQ_ID
, BILL_PROJECT_ID BILL_PROJECT_ID
, BILL_TASK_ID BILL_TASK_ID
, BILL_ORGANIZATION_ID BILL_ORGANIZATION_ID
, BILL_FUND_REF1 BILL_FUND_REF1
, BILL_FUND_REF2 BILL_FUND_REF2
, BILL_FUND_REF3 BILL_FUND_REF3
, BILL_BILL_OF_LADING BILL_BILL_OF_LADING
, BILL_SERIAL_NUM BILL_SERIAL_NUM
, BILL_CURRENCY_CODE BILL_CURRENCY_CODE
, BILL_RATE_TYPE BILL_RATE_TYPE
, BILL_RATE_DATE BILL_RATE_DATE
, BILL_EXCHANGE_RATE BILL_EXCHANGE_RATE
, BILL_DESCRIPTION BILL_DESCRIPTION
, BILL_QUANTITY BILL_QUANTITY
, BILL_UNIT_PRICE BILL_UNIT_PRICE
, REVENUE_AMOUNT REVENUE_AMOUNT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, WEIGHT WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, REQUISITION_LINE_TYPE_ID REQUISITION_LINE_TYPE_ID
, PO_CATEGORY_ID PO_CATEGORY_ID
FROM "OKE"."OKE_K_DELIVERABLES_B"