[Home] [Help]
View: CST_PROJMFG_CMT_STUB_V
View Text
SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
FROM PA_IMPLEMENTATIONS_ALL
WHERE 1=2
Columns
Name |
PROJECT_ID |
TASK_ID |
TRANSACTION_SOURCE |
LINE_TYPE |
CMT_NUMBER |
CMT_DISTRIBUTION_ID |
CMT_HEADER_ID |
DESCRIPTION |
EXPENDITURE_ITEM_DATE |
PA_PERIOD |
GL_PERIOD |
CMT_LINE_NUMBER |
CMT_CREATION_DATE |
CMT_APPROVED_DATE |
CMT_REQUESTOR_NAME |
CMT_BUYER_NAME |
CMT_APPROVED_FLAG |
CMT_PROMISED_DATE |
CMT_NEED_BY_DATE |
ORGANIZATION_ID |
VENDOR_ID |
VENDOR_NAME |
EXPENDITURE_TYPE |
EXPENDITURE_CATEGORY |
REVENUE_CATEGORY |
SYSTEM_LINKAGE_FUNCTION |
UNIT_OF_MEASURE |
UNIT_PRICE |
CMT_IND_COMPILED_SET_ID |
DENOM_RAW_COST |
DENOM_BURDENED_COST |
ACCT_RAW_COST |
ACCT_BURDENED_COST |
TOT_CMT_QUANTITY |
QUANTITY_ORDERED |
AMOUNT_ORDERED |
ORIGINAL_QUANTITY_ORDERED |
ORIGINAL_AMOUNT_ORDERED |
QUANTITY_CANCELLED |
AMOUNT_CANCELLED |
QUANTITY_DELIVERED |
AMOUNT_DELIVERED |
DENOM_AMOUNT_DELIVERED |
QUANTITY_INVOICED |
AMOUNT_INVOICED |
QUANTITY_OUTSTANDING_DELIVERY |
AMOUNT_OUTSTANDING_DELIVERY |
QUANTITY_OUTSTANDING_INVOICE |
DENOM_AMT_OUTSTANDING_INVOICE |
AMOUNT_OUTSTANDING_INVOICE |
QUANTITY_OVERBILLED |
AMOUNT_OVERBILLED |
ORIGINAL_TXN_REFERENCE1 |
ORIGINAL_TXN_REFERENCE2 |
ORIGINAL_TXN_REFERENCE3 |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
ACCT_RATE_DATE |
ACCT_RATE_TYPE |
ACCT_EXCHANGE_RATE |
DENOM_CURRENCY_CODE |
ACCT_CURRENCY_CODE |
INVENTORY_ITEM_ID |
INVENTORY_ITEM_NAME |
WIP_RESOURCE_ID |
WIP_RESOURCE_NAME |
UOM_MEANING |