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

Object Details

Object Name:	PJM_PROJECT_COMMIT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_PROJECT_COMMIT_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_PROJECT_COMMIT_V returns project level commitment summaries.
This view corresponds to the Project Commitments web inquiry region.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a project
TASK_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a task
RESOURCE_LIST_MEMBER_ID	NUMBER			Unique identifier for the member of a resource list
CMT_LINE_ID	NUMBER	(15)	Yes	Comment line unique identifier
SUPPLIER_ID	NUMBER			Supplier unique identifier
SUPPLIER_NAME	VARCHAR2	(240)		Supplier name
COMMITMENT_DATE	DATE			Date of the commitment
COMMITMENT_TYPE	VARCHAR2	(80)	Yes	Type of commitment
COMMITMENT_NUMBER	VARCHAR2	(240)		Document number of the commitment
COMMITMENT_LINE_NUMBER	NUMBER			Document line number of the commitment
COMMITMENT_AMT	VARCHAR2	(4000)		Amount of commitment
BURDENED_COST	VARCHAR2	(4000)		Burdened cost
APPROVED_DATE	DATE			Date on which the requisition, purchase order or invoice is approved
PROMISED_DATE	DATE			Promised delivery date for commitment
NEED_BY_DATE	DATE			Date commitment is needed by
DESCRIPTION	VARCHAR2	(255)		The description of either the requisition or purchase order line or the invoice distribution
TASK_NUMBER	VARCHAR2	(25)	Yes	User-entered string that uniquely identifies a task within a project
TASK_NAME	VARCHAR2	(20)	Yes	User-entered task name
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Commitment expenditure type
EXPENDITURE_ORG	VARCHAR2	(240)	Yes	Expenditure organization incurring the commitment
APPROVED_FLAG	VARCHAR2	(1)		Flag indicating whether the commitment has been approved
QUANTITY	NUMBER			Outstanding quantity of the commitment distribution
UOM	VARCHAR2	(30)		Unit of measure
REQUESTOR	VARCHAR2	(240)		Requestor name
BUYER	VARCHAR2	(240)		Buyer name
TRANSACTION_SOURCE	VARCHAR2	(80)	Yes	Source of commitment,,for example ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code
DENOM_RAW_COST	VARCHAR2	(4000)		Transaction currency raw cost amount of the project-related commitment distribution
DENOM_BURDENED_COST	VARCHAR2	(4000)		Transaction currency burdened cost amount of the project-related commitment distribution
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code
ACCT_RAW_COST	VARCHAR2	(4000)		Raw cost amount of the project-related commitment distribution
ACCT_BURDENED_COST	VARCHAR2	(4000)		Burdened cost amount of the project-related commitment distribution
ACCT_RATE_DATE	DATE			Functional currency exchange rate date
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional currency exchange rate type
ACCT_EXCHANGE_RATE	NUMBER			Exchange rate to functional currency
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Receipt currency code
RECEIPT_CURRENCY_AMOUNT	VARCHAR2	(4000)		For expense reports, the receipt currency amount. For all the other rows, this value is null
RECEIPT_EXCHANGE_RATE	NUMBER			Exchange rate to receipt currency
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code
PROJECT_RATE_DATE	DATE			Project currency exchange rate date
PROJECT_RATE_TYPE	VARCHAR2	(30)		Project currency exchange rate type
PROJECT_EXCHANGE_RATE	NUMBER			Exchange rate to project currency
CMT_REJECTION_CODE	VARCHAR2	(4000)		The reason why the item was rejected during commitments summarization

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      CMT_LINE_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      COMMITMENT_DATE
,      COMMITMENT_TYPE
,      COMMITMENT_NUMBER
,      COMMITMENT_LINE_NUMBER
,      COMMITMENT_AMT
,      BURDENED_COST
,      APPROVED_DATE
,      PROMISED_DATE
,      NEED_BY_DATE
,      DESCRIPTION
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG
,      APPROVED_FLAG
,      QUANTITY
,      UOM
,      REQUESTOR
,      BUYER
,      TRANSACTION_SOURCE
,      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
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      CMT_REJECTION_CODE
FROM APPS.PJM_PROJECT_COMMIT_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_COMMIT_V references the following:

APPS: FND_CURRENCIES; FND_CURRENCY_CACHE - show dependent code; FND_MESSAGE_CACHE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; PA_COMMITMENT_TXNS; PA_LOOKUPS; PA_TASKS; PA_TXN_ACCUM_DETAILS

APPS.PJM_PROJECT_COMMIT_V is not referenced by any database object