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_PROJ_REQ_DISTRIBUTIONS

Object Details

Object Name:	PA_PROJ_REQ_DISTRIBUTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_REQ_DISTRIBUTIONS
Subobject Name:
Status:	VALID

View Type

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

View that displays project-related distributions in Oracle Purchasing that have not yet been purchased as a purchase order.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQ_NUMBER	VARCHAR2	(20)	Yes	Requisition number
DOCUMENT_TYPE	VARCHAR2	(80)	Yes	Document type name
APPROVED_FLAG	VARCHAR2	(1)		Authorization status type
REQ_LINE	NUMBER		Yes	Requisition Line number
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes	Item description
NEED_BY_DATE	DATE			Date the requisition is needed internally
CREATION_DATE	DATE			Standard Who Column
VENDOR_NAME	VARCHAR2	(240)		Supplier name
VENDOR_ID	NUMBER			Supplier unique identifier
REQUESTOR_PERSON_ID	NUMBER	(10)	Yes	System generated for the requestor
REQUESTOR_NAME	VARCHAR2	(240)		Requestor Name
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency Code
DENOM_AMOUNT	NUMBER			Transaction Amount
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional Currency Code
ACCT_RATE_DATE	DATE			Functional Rate Date
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional Rate Type
ACCT_EXCHANGE_RATE	NUMBER			Functional Exchange Rate
UNIT	VARCHAR2	(25)		Unit
UNIT_PRICE	NUMBER			Unit Price
QUANTITY	NUMBER			Quantity for the distribution
AMOUNT	NUMBER			Amount
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The project number that uniquely identifies the project
PROJECT_NAME	VARCHAR2	(30)	Yes	User-defined name that uniquely identifies the project
TASK_NUMBER	VARCHAR2	(25)	Yes	User-defined number that uniquely identifies the task within a project
TASK_NAME	VARCHAR2	(20)	Yes	User-defined short name of the task
EXPENDITURE_TYPE	VARCHAR2	(30)		Project accounting expenditure type
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	Expenditure Category
REVENUE_CATEGORY	VARCHAR2	(30)	Yes	Revenue Category
EXPENDITURE_ITEM_DATE	DATE			Project accounting expenditure item date
EXPENDITURE_ORGANIZATION	VARCHAR2	(240)	Yes	Expenditure Organization
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition header unique identifier
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
REQ_DISTRIBUTION_ID	NUMBER		Yes	Requisition distribution unique identifier
PROJECT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the project
TASK_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the task.
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	Identifier of the expenditrue organization
RESOURCE_CLASS	CHAR	(18)		Resource Class
ORG_ID	NUMBER			Operating unit identifier for multi-organization installations
AWARD_SET_ID	NUMBER	(15)		Award Distribution Identifer for Grants Accounting
CBS_ELEMENT_ID	NUMBER			This is the unique identifier of the cost code element.

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
,      RESOURCE_CLASS
,      ORG_ID
,      AWARD_SET_ID
,      CBS_ELEMENT_ID
FROM APPS.PA_PROJ_REQ_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.PA_PROJ_REQ_DISTRIBUTIONS references the following:

APPS: FND_PROFILE - show dependent code; GL_LEDGERS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PA_EXPENDITURE_TYPES; PA_MULTI_CURRENCY - show dependent code; PA_PROJECTS_ALL; PA_TASKS; PA_TASKS_EXPEND_V; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_TL; PO_LINE_TYPES; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL

APPS.PA_PROJ_REQ_DISTRIBUTIONS is referenced by following:

APPS: GMS_COMMITMENTS_OVERRIDE_V; GMS_PA_API3 - show dependent code; PA_COMMITMENT_TXNS_V; PA_PROJ_APPR_REQ_DISTRIBUTIONS; PA_PROJ_PEND_REQ_DISTRIBUTIONS