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]

TABLE: PA.PA_COMMITMENT_TXNS

Object Details

Object Name:	PA_COMMITMENT_TXNS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_COMMITMENT_TXNS
Subobject Name:
Status:	VALID

PA_COMMITMENT_TXNS stores information about summarized
commitments for each project. Commitments for a given project are
refreshed every time the project summary amounts
are updated. All the commitments are summarized in the PA or GL
period for which CURRENT_PA_PERIOD_FLAG in the PA_PERIODS table is
set to 'Y'.
.
.
You can define which commitments you want to summarize by modifying
the commitments view. Refer to the Oracle Projects User's Guide
for information about implementing commitments from external systems.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_COMMITMENT_TXNS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CMT_LINE_ID
PA_COMMITMENT_TXNS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
PA_COMMITMENT_TXNS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BURDEN_SUM_SOURCE_RUN_ID
PA_COMMITMENT_TXNS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BURDEN_SUM_DEST_RUN_ID
PA_COMMITMENT_TXNS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CMT_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CMT_LINE_ID	NUMBER	(15)	Yes	Identifier of the commitment.
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project.
TASK_ID	NUMBER	(15)	Yes	Identifier of the lowest level task.
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes	Source of commitment, i.e., ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM.
LINE_TYPE	VARCHAR2	(1)	Yes	Commitment line type is part of QuickCode.
CMT_NUMBER	VARCHAR2	(240)		The number of the commitment document.
CMT_DISTRIBUTION_ID	NUMBER			The identifier of the requisition or purchase order distribution.
DESCRIPTION	VARCHAR2	(255)		The description of either the requisition or purchase order line or the invoice distribution.
EXPENDITURE_ITEM_DATE	DATE		Yes	The expenditure item date on which you expect to incur the commitment costs.
PA_PERIOD	VARCHAR2	(20)	Yes	PA period corresponding to the commitment.
GL_PERIOD	VARCHAR2	(15)	Yes	GL period corresponding to the commitment.
CMT_LINE_NUMBER	NUMBER			The requisition, purchase order or invoice line number in which the distribution is included.
CMT_CREATION_DATE	DATE			Date on which the requisition or purchase order was created or the invoice was incurred.
CMT_APPROVED_DATE	DATE			Date on which the requisition, purchase order or invoice was approved
CMT_REQUESTOR_NAME	VARCHAR2	(240)		The full name of requestor.
CMT_BUYER_NAME	VARCHAR2	(240)		The full name of buyer.
CMT_APPROVED_FLAG	VARCHAR2	(1)		Indicator if the commitment is approved: 'Y' for approved, 'N' for not approved.
CMT_PROMISED_DATE	DATE			Promised delivery date for commitment.
CMT_NEED_BY_DATE	DATE			Date that commitment is needed by.
CMT_HEADER_ID	NUMBER			Identifier for the Supplier on a commitment document.
ORGANIZATION_ID	NUMBER			Identifier of the expenditure organization incurring the commitment.
VENDOR_ID	NUMBER			Identifier of the Supplier.
VENDOR_NAME	VARCHAR2	(240)		Supplier Name.
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Commitment expenditure type.
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	The expenditure category of the commitment expenditure type.
REVENUE_CATEGORY	VARCHAR2	(30)	Yes	The revenue category of the commitment expenditure type.
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)	Yes	Commitment system linkage function: VENDOR_INVOICES.
UNIT_OF_MEASURE	VARCHAR2	(30)		Not currently used in Oracle Projects, Version 4.0.
UNIT_PRICE	NUMBER			Cost per unit of the project-related commitment distribution.
CMT_IND_COMPILED_SET_ID	NUMBER	(15)		Identifier for the commitment's burden compiled set.
TOT_CMT_RAW_COST	NUMBER			The project currency raw cost amount of the project-related commitment distribution. This amount is derived by the commitment summarization process.
TOT_CMT_BURDENED_COST	NUMBER			The project currency burdened cost amount of the project-related commitment distribution. This amount is derived by the commitment summarization process.
TOT_CMT_QUANTITY	NUMBER			Outstanding quantity of the project-related commitment distribution.
QUANTITY_ORDERED	NUMBER			Distribution quantity ordered.
AMOUNT_ORDERED	NUMBER			Distribution amount ordered.
ORIGINAL_QUANTITY_ORDERED	NUMBER			Distribution original quantity ordered.
ORIGINAL_AMOUNT_ORDERED	NUMBER			Distribution original amount ordered.
QUANTITY_CANCELLED	NUMBER			Distribution quantity cancelled.
AMOUNT_CANCELLED	NUMBER			Distribution amount cancelled.
QUANTITY_DELIVERED	NUMBER			Distribution quantity delivered.
AMOUNT_DELIVERED	NUMBER			Distribution amount delivered.
QUANTITY_INVOICED	NUMBER			Distribution quantity invoiced.
AMOUNT_INVOICED	NUMBER			Distribution amount invoiced.
QUANTITY_OUTSTANDING_DELIVERY	NUMBER			Distribution quantity outstanding delivery.
AMOUNT_OUTSTANDING_DELIVERY	NUMBER			Distribution amount outstanding delivery.
QUANTITY_OUTSTANDING_INVOICE	NUMBER			Distribution quantity outstanding invoice.
AMOUNT_OUTSTANDING_INVOICE	NUMBER			Distribution amount outstanding invoice.
QUANTITY_OVERBILLED	NUMBER			Distribution quantity overbilled.
AMOUNT_OVERBILLED	NUMBER			Distribution amount overbilled.
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(30)		Used to store original transaction reference for commitments from external systems.
ORIGINAL_TXN_REFERENCE2	VARCHAR2	(15)		Used to store original transaction reference for commitments from external systems.
ORIGINAL_TXN_REFERENCE3	VARCHAR2	(15)		Used to store original transaction reference for commitments from external systems.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)		Burden summarization source run id. Id will identify all the commitment items summarized in the run to create summarized commitment items
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)		Burden summarization Destination run id. Id will identify commitment items created by burden component summarization process
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)		Burden component summarization rejection code
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		For expense reports, the receipt currency code (the currency in which the expenses originally occurred).
RECEIPT_CURRENCY_AMOUNT	NUMBER			For expense reports, the receipt currency amount. For all the other rows, this value is null.
RECEIPT_EXCHANGE_RATE	NUMBER			For expense reports, the exchange rate to convert from the receipt currency to the transaction currency.
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code.
DENOM_RAW_COST	NUMBER			The transaction currency raw cost amount of the project-related commitment distribution.
DENOM_BURDENED_COST	NUMBER			The transaction currency burdened cost amount of the project-related commitment distribution.
ACCT_CURRENCY_CODE	VARCHAR2	(15)		The functional currency code.
ACCT_RAW_COST	NUMBER			The functional currency raw cost amount of the project-related commitment distribution.
ACCT_BURDENED_COST	NUMBER			The functional currency burdened cost amount of the project-related commitment distribution.
ACCT_RATE_DATE	DATE			The functional currency rate date.
ACCT_RATE_TYPE	VARCHAR2	(30)		The functional currency rate type (such as Spot or Corporate).
ACCT_EXCHANGE_RATE	NUMBER			The functional currency exchange rate.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code.
PROJECT_RATE_DATE	DATE			The project currency rate date.
PROJECT_RATE_TYPE	VARCHAR2	(30)		The project currency rate type (such as Spot or Corporate).
PROJECT_EXCHANGE_RATE	NUMBER			The project currency exchange rate.
CMT_REJECTION_CODE	VARCHAR2	(80)		The reason why the item was rejected during commitments summarization.
GENERATION_ERROR_FLAG	VARCHAR2	(1)		Flag that indicates whether the item has encountered errors during commitments summarization. If Errors, this flag is set to Y.
INVENTORY_ITEM_ID	NUMBER	(15)		Identifier for inventory item
BOM_LABOR_RESOURCE_ID	NUMBER	(15)		Identifier for BOM labor resource
BOM_EQUIPMENT_RESOURCE_ID	NUMBER	(15)		Identifier for BOM equipment resource
PROJ_RAW_COST	NUMBER			Project raw cost amount
PROJ_BURDENED_COST	NUMBER			Project burdened cost amount
PROJ_CURRENCY_CODE	VARCHAR2	(15)		Project currency code
PROJ_RATE_DATE	DATE			Project rate date
PROJ_RATE_TYPE	VARCHAR2	(30)		Project rate type
PROJ_EXCHANGE_RATE	NUMBER			Project exchange rate
UOM_CODE	VARCHAR2	(30)		Unit of measure code
RESOURCE_CLASS	VARCHAR2	(30)		Holds the code used to identify the resource class.The supported resource class codes are PEOPLE, EQUIPMENT,MATERIAL_ITEMS and FINANCIAL_ELEMENTS.
SRC_SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)		The system linkage of the source expenditure items which were summarized to create separate burden transaction.
CBS_ELEMENT_ID	NUMBER	(15)		This is the unique identifier of the cost code element.

Query Text

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


SELECT CMT_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      TRANSACTION_SOURCE
,      LINE_TYPE
,      CMT_NUMBER
,      CMT_DISTRIBUTION_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
,      CMT_HEADER_ID
,      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
,      TOT_CMT_RAW_COST
,      TOT_CMT_BURDENED_COST
,      TOT_CMT_QUANTITY
,      QUANTITY_ORDERED
,      AMOUNT_ORDERED
,      ORIGINAL_QUANTITY_ORDERED
,      ORIGINAL_AMOUNT_ORDERED
,      QUANTITY_CANCELLED
,      AMOUNT_CANCELLED
,      QUANTITY_DELIVERED
,      AMOUNT_DELIVERED
,      QUANTITY_INVOICED
,      AMOUNT_INVOICED
,      QUANTITY_OUTSTANDING_DELIVERY
,      AMOUNT_OUTSTANDING_DELIVERY
,      QUANTITY_OUTSTANDING_INVOICE
,      AMOUNT_OUTSTANDING_INVOICE
,      QUANTITY_OVERBILLED
,      AMOUNT_OVERBILLED
,      ORIGINAL_TXN_REFERENCE1
,      ORIGINAL_TXN_REFERENCE2
,      ORIGINAL_TXN_REFERENCE3
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      CMT_REJECTION_CODE
,      GENERATION_ERROR_FLAG
,      INVENTORY_ITEM_ID
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIPMENT_RESOURCE_ID
,      PROJ_RAW_COST
,      PROJ_BURDENED_COST
,      PROJ_CURRENCY_CODE
,      PROJ_RATE_DATE
,      PROJ_RATE_TYPE
,      PROJ_EXCHANGE_RATE
,      UOM_CODE
,      RESOURCE_CLASS
,      SRC_SYSTEM_LINKAGE_FUNCTION
,      CBS_ELEMENT_ID
FROM PA.PA_COMMITMENT_TXNS;

Dependencies

[top of page]

PA.PA_COMMITMENT_TXNS does not reference any database object

PA.PA_COMMITMENT_TXNS is referenced by following:

PA: PA_COMMITMENT_TXNS#