[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 |
APPS.CST_PROJMFG_CMT_STUB_V