Skip to content FND Design Data [Home] [Help]

View: CST_PROJMFG_CMT_STUB_V

Product: BOM - Bills of Material
Description:
Implementation/DBA Data: ViewAPPS.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