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_REQ_COMMITMENTS_STUB_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

PJM_REQ_COMMITMENTS_STUB_V is designed for non-Project Manufacturing customers only. It retains the view signature of the PJM_REQ_COMMITMENTS_BASIC_V but will not return any rows. This view is provided to improve performance of the Commitments module.

[View Source]

Columns

Name	Datatype	Length	Comments
REQ_NUMBER	VARCHAR2	(20)	Purchase requisition number
DOCUMENT_TYPE	VARCHAR2	(80)	Procurement document type
APPROVED_FLAG	VARCHAR2	(1)	Flag indicating purchase requisition is approved
REQ_LINE	NUMBER		Requisition line number
ITEM_DESCRIPTION	VARCHAR2	(240)	Item description
NEED_BY_DATE	DATE		Purchase requisition need-by date
CREATION_DATE	DATE		Date purchase requisition created
VENDOR_NAME	VARCHAR2	(80)	Supplier name
VENDOR_ID	NUMBER		Supplier unique identifier
REQUESTOR_PERSON_ID	NUMBER		Requestor unique identifier
REQUESTOR_NAME	VARCHAR2	(240)	Requestor name
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Transaction currency code
DENOM_AMOUNT	NUMBER		Requisition amount in purchase requisition currency
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Functional currency code
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
UNIT	VARCHAR2	(25)	Unit of measure
UNIT_PRICE	NUMBER		Cost per unit of the project-related commitment distribution
QUANTITY	NUMBER		Quantity requested
AMOUNT	NUMBER		Requisition amount in functional currency
PROJECT_NUMBER	VARCHAR2	(25)	User-entered number that uniquely identifies a project or seiban
PROJECT_NAME	VARCHAR2	(30)	User-entered project/seiban name
TASK_NUMBER	VARCHAR2	(25)	User-entered string that uniquely identifies a task within a project
TASK_NAME	VARCHAR2	(20)	User-entered task name
EXPENDITURE_TYPE	VARCHAR2	(30)	Commitment expenditure type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Expenditure category of the commitment
REVENUE_CATEGORY	VARCHAR2	(30)	Revenue category of the commitment
EXPENDITURE_ITEM_DATE	DATE		Date on which you expect to incur the commitment costs
EXPENDITURE_ORGANIZATION	VARCHAR2	(60)	Expenditure organization incurring the commitment
REQUISITION_HEADER_ID	NUMBER		Purchase requisition header unique identifier
REQUISITION_LINE_ID	NUMBER		Purchase requisition line unique identifier
REQ_DISTRIBUTION_ID	NUMBER		Purchase requisition distribution unique identifier
PROJECT_ID	NUMBER		System-generated number that uniquely identifies a project or seiban
TASK_ID	NUMBER		Task unique identifier
EXPENDITURE_ORGANIZATION_ID	NUMBER		Unique identifier of the expenditure organization incurring the commitment
INVENTORY_ITEM_ID	NUMBER		Inventory item unique identifier
INVENTORY_ITEM_NAME	VARCHAR2	(240)	Item Name
WIP_RESOURCE_ID	NUMBER		Resource unique identifier
WIP_RESOURCE_NAME	VARCHAR2	(340)	Resource name
UOM_CODE	VARCHAR2	(3)	Code for Unit of Measure
UNIT_OF_MEASURE	VARCHAR2	(25)	Unit of Measure

Query Text

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


SELECT REQ_NUMBER
,      DOCUMENT_TYPE
,      APPROVED_FLAG
,      REQ_LINE
,      ITEM_DESCRIPTION
,      NEED_BY_DATE
,      CREATION_DATE
,      VENDOR_NAME
,      VENDOR_ID
,      REQUESTOR_PERSON_ID
,      REQUESTOR_NAME
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      UNIT
,      UNIT_PRICE
,      QUANTITY
,      AMOUNT
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      WIP_RESOURCE_ID
,      WIP_RESOURCE_NAME
,      UOM_CODE
,      UNIT_OF_MEASURE
FROM APPS.PJM_REQ_COMMITMENTS_STUB_V;

Dependencies

[top of page]

APPS.PJM_REQ_COMMITMENTS_STUB_V references the following:

APPS: PA_IMPLEMENTATIONS_ALL

APPS.PJM_REQ_COMMITMENTS_STUB_V is referenced by following:

APPS: PJM_REQ_COMMITMENTS_V