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.PA_COMMITMENTS_V1

Object Details

Object Name:	PA_COMMITMENTS_V1
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER		Identifier of the project.
TASK_ID	NUMBER		Identifier of the lowest task
TRANSACTION_SOURCE	VARCHAR2	(17)	Source of commitment, i.e., ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM.
LINE_TYPE	VARCHAR2	(1)	Commitment line type: (R)equisition, (P)urchase Order, (I) Supplier Invoice.
CMT_NUMBER	VARCHAR2	(50)	The commitment document number: requisition, purchase order or invoice number.
CMT_DISTRIBUTION_ID	NUMBER		The identifier of the requisition or purchase order distribution.
CMT_HEADER_ID	NUMBER		Identifier for the requisition, purchase order or invoice header.
DESCRIPTION	VARCHAR2	(240)	The description of either the requisition or purchase order line or the invoice distribution.
EXPENDITURE_ITEM_DATE	DATE		The expenditure item date on which you expect to incur the commitment costs.
PA_PERIOD	VARCHAR2	(0)	PA period corresponding to the commitment.
GL_PERIOD	VARCHAR2	(0)	GL period corresponding to the commitment PA period.
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	(4000)	The full name of requestor.
CMT_BUYER_NAME	VARCHAR2	(4000)	The full name of buyer.
CMT_APPROVED_FLAG	VARCHAR2	(1)	Indicator if the commiment 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.
ORGANIZATION_ID	NUMBER		Identifier of the expenditure organization incurring the commitment.
VENDOR_ID	NUMBER		Identifier of the Supplier.
VENDOR_NAME	VARCHAR2	(4000)	Supplier Name.
EXPENDITURE_TYPE	VARCHAR2	(4000)	Commitment expenditure type.
EXPENDITURE_CATEGORY	VARCHAR2	(30)	The expenditure category of the commitment .
REVENUE_CATEGORY	VARCHAR2	(30)	The revenue category of the commitment.
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(2)	Commitment system linkage function: VENDOR_INVOICES.
UNIT_OF_MEASURE	VARCHAR2	(4000)	Not currently used in Oracle Projects
UNIT_PRICE	NUMBER		Cost per unit of the project-related commitment distribution.
CMT_IND_COMPILED_SET_ID	NUMBER		Identifier for the indirect compiled set.
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.
TOT_CMT_QUANTITY	NUMBER		Outstanding quantity of the project-related commitment distribution.
QUANTITY_ORDERED	NUMBER		Distribution quantity ordered of the purchase order commitment.
AMOUNT_ORDERED	NUMBER		Distribution amount ordered of the purchase order commitment.
ORIGINAL_QUANTITY_ORDERED	NUMBER		Distribution original quantity ordered of the purchase order commitment.
ORIGINAL_AMOUNT_ORDERED	NUMBER		Distribution original amount ordered of the purchase order commitment.
QUANTITY_CANCELLED	NUMBER		Distribution quantity cancelled of the purchase order commitment.
AMOUNT_CANCELLED	NUMBER		Distribution amount cancelled of the purchase order commitment.
QUANTITY_DELIVERED	NUMBER		Distribution quantity delivered of the purchase order commitment.
QUANTITY_INVOICED	NUMBER		Distribution quantity invoiced of the purchase order commitment.
AMOUNT_INVOICED	NUMBER		Distribution amount invoiced of the purchase order commitment.
QUANTITY_OUTSTANDING_DELIVERY	NUMBER		Distribution quantity outstanding delivery of the purchase order commitment.
AMOUNT_OUTSTANDING_DELIVERY	NUMBER		Distribution amount outstanding delivery of the purchase order commitment.
QUANTITY_OUTSTANDING_INVOICE	NUMBER		Distribution quantity outstanding invoice of the purchase order commitment.
AMOUNT_OUTSTANDING_INVOICE	NUMBER		Distribution amount outstanding invoice of the purchase order commitment.
QUANTITY_OVERBILLED	NUMBER		Distribution quantity overbilled of the purchase order commitment.
AMOUNT_OVERBILLED	NUMBER		Distribution amount overbilled of the purchase order commitment.
ORIGINAL_TXN_REFERENCE1	VARCHAR2	(0)	Original transaction reference-1.
ORIGINAL_TXN_REFERENCE2	VARCHAR2	(0)	Original transaction reference-2.
ORIGINAL_TXN_REFERENCE3	VARCHAR2	(0)	Original transaction reference-3.
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		Standard Who Column
CREATION_DATE	DATE		Standard Who Column
CREATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		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
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_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.
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.
INVENTORY_ITEM_ID	NUMBER		The Inventory Item Identifier.
INVENTORY_ITEM_NAME	VARCHAR2	(4000)	The Inventory Item.
WIP_RESOURCE_ID	NUMBER		The WIP Resource Identifier.
WIP_RESOURCE_NAME	VARCHAR2	(4000)	The WIP Resource.
UOM_CODE	VARCHAR2	(4000)	The Unit Of Measure Code.
RESOURCE_CLASS	VARCHAR2	(18)	The resource class of the transaction.

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
,      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
,      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_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      WIP_RESOURCE_ID
,      WIP_RESOURCE_NAME
,      UOM_CODE
,      RESOURCE_CLASS
FROM APPS.PA_COMMITMENTS_V1;

Dependencies

[top of page]

APPS.PA_COMMITMENTS_V1 references the following:

APPS: AP_INVOICES_PKG - show dependent code; CST_PROJMFG_CMT_VIEW; PA_BURDEN_CMTS - show dependent code; PA_CMT_UTILS - show dependent code; PA_FUNDS_CONTROL_UTILS - show dependent code; PA_MULTI_CURRENCY - show dependent code; PA_PJC_CWK_UTILS - show dependent code; PA_PJM_PO_COMMITMENTS_TMP; PA_PJM_REQ_COMMITMENTS_TMP; PA_PROJ_AP_INV_DIST_V1; PA_PROJ_AP_INV_DIST_V2; PA_PROJ_PO_DISTRIBUTIONS_V1; PA_PROJ_PO_DISTRIBUTIONS_V2; PA_PROJ_REQ_DISTRIBUTIONS_V1; PA_PROJ_SUMM_TMP

APPS.PA_COMMITMENTS_V1 is referenced by following:

APPS: PA_PROJ_ACCUM_MAIN - show dependent code