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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQ_DISTRIBUTION_ID	NUMBER		Yes	Requisition distribution unique identifier
REQ_DISTRIBUTION_NUM	NUMBER		Yes	Distribution number
REQ_DISTRIBUTION_TYPE	CHAR	(11)		This contains the value REQUISITION always
GL_DATE	DATE			Accounting Date
REQ_DIST_CHARGE_ACCOUNT	NUMBER		Yes	Charge Account
BUDGET_ACCOUNT	NUMBER			Budget Account
REQ_BUDGET_ACCOUNT	NUMBER			Requisition Budget Account
ORIGINATING_REQ_DIST_ID	NUMBER			Distribution unique identifier that indicates whether the distribution is encumbered when it is cancelled
REQ_RESERVED_FLAG	VARCHAR2	(1)		Encumbered? Indicator
PROJECT_ID	NUMBER			Project Identifier
PROJECT_NAME	VARCHAR2	(30)		Project
TASK_ID	NUMBER			Task Identifier
TASK_NAME	VARCHAR2	(20)		Task
EXPENDITURE_ORGANIZATION_ID	NUMBER			Expenditure Org Identifier
EXPENDITURE_ORG	VARCHAR2	(240)	Yes	Expenditure Org
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure Type
AWARD_ID	NUMBER	(15)		Award Identifier
AWARD_NUMBER	VARCHAR2	(15)		Award Number
PREVENT_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Prevent Encumbrance Indicator
REQ_DIST_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
REQ_DIST_ATTRIBUTE1	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment 1
REQ_DIST_ATTRIBUTE2	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment2
REQ_DIST_ATTRIBUTE3	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment3
REQ_DIST_ATTRIBUTE4	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment4
REQ_DIST_ATTRIBUTE5	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment5
REQ_DIST_ATTRIBUTE6	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment6
REQ_DIST_ATTRIBUTE7	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment7
REQ_DIST_ATTRIBUTE8	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment8
REQ_DIST_ATTRIBUTE9	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment9
REQ_DIST_ATTRIBUTE10	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment10
REQ_DIST_ATTRIBUTE11	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment11
REQ_DIST_ATTRIBUTE12	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment12
REQ_DIST_ATTRIBUTE13	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment13
REQ_DIST_ATTRIBUTE14	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment14
REQ_DIST_ATTRIBUTE15	VARCHAR2	(150)		Requisition Distribution Descriptive Flexfield Segment15
ORG_ID	NUMBER			Organization identifier
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes	Operating Unit Name
LEDGER_ID	NUMBER		Yes	Ledger_ID
LEDGER_CURRENCY	VARCHAR2	(15)	Yes	Ledger Currency
REQUISITION_LINE_QUANTITY	NUMBER			Quantity ordered
UNIT_PRICE	NUMBER			Unit Price
AMOUNT_ORDERED	NUMBER			Distribution Amount
REQ_LINE_CURRENCY_AMOUNT	NUMBER			Distribution Currency Amount

Query Text

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


SELECT REQ_DISTRIBUTION_ID
,      REQ_DISTRIBUTION_NUM
,      REQ_DISTRIBUTION_TYPE
,      GL_DATE
,      REQ_DIST_CHARGE_ACCOUNT
,      BUDGET_ACCOUNT
,      REQ_BUDGET_ACCOUNT
,      ORIGINATING_REQ_DIST_ID
,      REQ_RESERVED_FLAG
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG
,      EXPENDITURE_TYPE
,      AWARD_ID
,      AWARD_NUMBER
,      PREVENT_ENCUMBRANCE_FLAG
,      REQ_DIST_ATTRIBUTE_CATEGORY
,      REQ_DIST_ATTRIBUTE1
,      REQ_DIST_ATTRIBUTE2
,      REQ_DIST_ATTRIBUTE3
,      REQ_DIST_ATTRIBUTE4
,      REQ_DIST_ATTRIBUTE5
,      REQ_DIST_ATTRIBUTE6
,      REQ_DIST_ATTRIBUTE7
,      REQ_DIST_ATTRIBUTE8
,      REQ_DIST_ATTRIBUTE9
,      REQ_DIST_ATTRIBUTE10
,      REQ_DIST_ATTRIBUTE11
,      REQ_DIST_ATTRIBUTE12
,      REQ_DIST_ATTRIBUTE13
,      REQ_DIST_ATTRIBUTE14
,      REQ_DIST_ATTRIBUTE15
,      ORG_ID
,      OPERATING_UNIT_NAME
,      LEDGER_ID
,      LEDGER_CURRENCY
,      REQUISITION_LINE_QUANTITY
,      UNIT_PRICE
,      AMOUNT_ORDERED
,      REQ_LINE_CURRENCY_AMOUNT
FROM APPS.PO_REQ_DISTS_REF_V;

Dependencies

[top of page]

APPS.PO_REQ_DISTS_REF_V references the following:

APPS: GL_SETS_OF_BOOKS; GMS_AWARDS_ALL; HR_ALL_ORGANIZATION_UNITS_TL; PA_PROJECTS_ALL; PA_TASKS; PER_ALL_PEOPLE_F; PO_LINE_TYPES; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL; PO_SYSTEM_PARAMETERS_ALL; WIP_ENTITIES

APPS.PO_REQ_DISTS_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000002_PKG - show dependent code; XLA_00707_AAD_S_000005_BC_PKG - show dependent code; XLA_00707_AAD_S_000005_PKG - show dependent code; XLA_00707_AAD_S_000007_PKG - show dependent code; XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_BC_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code