VIEW: OKE.OKE_DELIVERABLE_ACTIONS#

Source

View Text - Preformatted

select ACTION_ID ACTION_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, ACTION_TYPE ACTION_TYPE, ACTION_NAME ACTION_NAME, PA_ACTION_ID PA_ACTION_ID, TASK_ID TASK_ID, DELIVERABLE_ID DELIVERABLE_ID, 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, IN_PROCESS_FLAG IN_PROCESS_FLAG, READY_FLAG READY_FLAG, INSPECTION_REQ_FLAG INSPECTION_REQ_FLAG, EXPECTED_DATE EXPECTED_DATE, INITIATE_DATE INITIATE_DATE, PROMISED_DATE PROMISED_DATE, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR, 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, 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, UNIT_PRICE UNIT_PRICE, CURRENCY_CODE CURRENCY_CODE, QUANTITY QUANTITY, UOM_CODE UOM_CODE from "OKE"."OKE_DELIVERABLE_ACTIONS"

View Text - HTML Formatted

SELECT ACTION_ID ACTION_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
, ACTION_TYPE ACTION_TYPE
, ACTION_NAME ACTION_NAME
, PA_ACTION_ID PA_ACTION_ID
, TASK_ID TASK_ID
, DELIVERABLE_ID DELIVERABLE_ID
, 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
, IN_PROCESS_FLAG IN_PROCESS_FLAG
, READY_FLAG READY_FLAG
, INSPECTION_REQ_FLAG INSPECTION_REQ_FLAG
, EXPECTED_DATE EXPECTED_DATE
, INITIATE_DATE INITIATE_DATE
, PROMISED_DATE PROMISED_DATE
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR
, 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
, 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
, UNIT_PRICE UNIT_PRICE
, CURRENCY_CODE CURRENCY_CODE
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
FROM "OKE"."OKE_DELIVERABLE_ACTIONS"