eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CST_PROJMFG_CMT_BASIC_V

Object Details

Object Name:	CST_PROJMFG_CMT_BASIC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_PROJMFG_CMT_BASIC_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER		Project Identifier
TASK_ID	NUMBER		Task Identifier
TRANSACTION_SOURCE	CHAR	(20)	Source of the commitment, i.e Oracle Manufacturing.
LINE_TYPE	CHAR	(1)	Commitment line type, could be Purchase Order or Requisition.
CMT_NUMBER	VARCHAR2	(20)	Commitment document number.
CMT_DISTRIBUTION_ID	NUMBER		Identifier of the Req or PO distrbution.
CMT_HEADER_ID	NUMBER		Transaction source or purchase order header identifier.
DESCRIPTION	VARCHAR2	(240)	Description of the Item on the document distribution.
EXPENDITURE_ITEM_DATE	DATE		Expenditure Item Date.
PA_PERIOD	VARCHAR2	(20)	PA period corresponding to the commitment.
GL_PERIOD	VARCHAR2	(15)	GL period corresponding to the PA period.
CMT_LINE_NUMBER	NUMBER		The line number of the commitment.
CMT_CREATION_DATE	DATE		Date on which the commitment was created.
CMT_APPROVED_DATE	DATE		Date on which the document was approved.
CMT_REQUESTOR_NAME	VARCHAR2	(0)	Name of the requestor.
CMT_BUYER_NAME	VARCHAR2	(0)	Name of the buyer.
CMT_APPROVED_FLAG	CHAR	(1)	Is the commitment approved - Y/N ?
CMT_PROMISED_DATE	DATE		Promised delivery date for the commitment.
CMT_NEED_BY_DATE	DATE		Date on which commitment is needed.
ORGANIZATION_ID	NUMBER		Expenditure organization_id.
VENDOR_ID	NUMBER		Supplier Id.
VENDOR_NAME	VARCHAR2	(240)	Supplier Name.
EXPENDITURE_TYPE	VARCHAR2	(4000)	Expenditure Type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Expenditure Category.
REVENUE_CATEGORY	VARCHAR2	(30)	Revenue Category.
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(15)	The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type in PA.
UNIT_OF_MEASURE	VARCHAR2	(3)	Unit of Measure.
UNIT_PRICE	NUMBER		Unit price.
CMT_IND_COMPILED_SET_ID	NUMBER		Identifier for indirect compiled set. Not currently used by mfg.
DENOM_RAW_COST	NUMBER
DENOM_BURDENED_COST	NUMBER
ACCT_RAW_COST	NUMBER
ACCT_BURDENED_COST	NUMBER
TOT_CMT_QUANTITY	NUMBER		Outstanding qty of the project related commitment distribution.
QUANTITY_ORDERED	NUMBER		Distribution ordered quantity.
AMOUNT_ORDERED	NUMBER		Distribution amount ordered.
ORIGINAL_QUANTITY_ORDERED	NUMBER		Original quantity ordered of the PO commitment.
ORIGINAL_AMOUNT_ORDERED	NUMBER		Original amount ordered of the commitment.
QUANTITY_CANCELLED	NUMBER		Quantity cancelled of the commitment.
AMOUNT_CANCELLED	NUMBER		Amount cancelled of the commitment.
QUANTITY_DELIVERED	NUMBER		Quantity delivered of the commitment.
AMOUNT_DELIVERED	NUMBER		Amount delivered of the commitment.
DENOM_AMOUNT_DELIVERED	NUMBER
QUANTITY_INVOICED	NUMBER		Qty invoiced of the commitment.
AMOUNT_INVOICED	NUMBER		Amount invoiced for the commitment.
QUANTITY_OUTSTANDING_DELIVERY	NUMBER		Quantity outstanding of the commitment.
AMOUNT_OUTSTANDING_DELIVERY	NUMBER		Amount outstanding of the commitment.
QUANTITY_OUTSTANDING_INVOICE	NUMBER		Quantity outstanding invoice.
DENOM_AMT_OUTSTANDING_INVOICE	NUMBER
AMOUNT_OUTSTANDING_INVOICE	NUMBER		Amount outstanding invoice.
QUANTITY_OVERBILLED	NUMBER		Quantity overbilled.
AMOUNT_OVERBILLED	NUMBER		Amount overbilled.
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(15)	Transaction Id of the Mfg transaction is stored here.
ORIGINAL_TXN_REFERENCE2	VARCHAR2	(15)	Transaction reference 2.
ORIGINAL_TXN_REFERENCE3	VARCHAR2	(15)	Transaction reference 3.
LAST_UPDATE_DATE	DATE		Who column.
LAST_UPDATED_BY	NUMBER		Who column.
CREATION_DATE	DATE		Who column.
CREATED_BY	NUMBER		Who column.
LAST_UPDATE_LOGIN	NUMBER		Who column.
REQUEST_ID	NUMBER		Who column.
PROGRAM_APPLICATION_ID	NUMBER		Who column.
PROGRAM_ID	NUMBER		Who column.
PROGRAM_UPDATE_DATE	DATE		Who column.
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(0)
ACCT_EXCHANGE_RATE	NUMBER
DENOM_CURRENCY_CODE	VARCHAR2	(15)
ACCT_CURRENCY_CODE	VARCHAR2	(15)
INVENTORY_ITEM_ID	NUMBER		INVENTORY ITEM ID
INVENTORY_ITEM_NAME	VARCHAR2	(40)	INVENTORY ITEM NAME
WIP_RESOURCE_ID	NUMBER		WIP RESOURCE ID on the transaction
WIP_RESOURCE_NAME	VARCHAR2	(10)	RESOURCE CODE
UOM_MEANING	VARCHAR2	(25)	UNIT OF MEASURE MEANING
ORG_ID	NUMBER	(15)	ORG ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      ORG_ID
FROM APPS.CST_PROJMFG_CMT_BASIC_V;

Dependencies

[top of page]

APPS.CST_PROJMFG_CMT_BASIC_V references the following:

APPS: BOM_RESOURCES; CST_COST_ELEM_EXP_TYPES; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; MTL_CST_ACTUAL_COST_DETAILS; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; MTL_UNITS_OF_MEASURE_TL; PA_EXPENDITURE_TYPES; PA_PERIODS; PJM_PROJECT_PARAMETERS; PJM_TASK_AUTO_ASSIGN - show dependent code; PO_HEADERS_ALL; PO_LINES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_VENDORS; PROJECT_MFG - show dependent code; RCV_TRANSACTIONS; WIP_DISCRETE_JOBS; WIP_OPERATIONS; WIP_TRANSACTIONS; WIP_TRANSACTION_ACCOUNTS

APPS.CST_PROJMFG_CMT_BASIC_V is not referenced by any database object