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

Object Details

Object Name:	POR_DISTRIBUTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_DISTRIBUTIONS_V
Subobject Name:
Status:	VALID

View Type

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

The POR_DISTRIBUTIONS_V returns account information that is assocated with each requisition line. It is used in displaying line details and billing information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRIBUTION_ID	NUMBER		Yes	Distribution Identifier
REQUISITION_LINE_ID	NUMBER		Yes	Requisition Line Identifier
CODE_COMBINATION_ID	NUMBER		Yes	GL Charge Account Identifier
REQ_LINE_QUANTITY	NUMBER			Quantity for Distribution
ENCUMBERED_FLAG	VARCHAR2	(1)		Indicates whether the distribution is encumbered
GL_ENCUMBERED_DATE	DATE			Date the distribution was encumbered
GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)		Period in which the distribution was encumbered
GL_CANCELLED_DATE	DATE			Date the distribution was cancelled
FAILED_FUNDS_LOOKUP_CODE	VARCHAR2	(25)		Type of approval failure for the distribution
ENCUMBERED_AMOUNT	NUMBER			Encumbered amount for distribution
BUDGET_ACCOUNT_ID	NUMBER			GL budget account unique identifier
ACCRUAL_ACCOUNT_ID	NUMBER			GL accrual account unique identifier
ORG_ID	NUMBER			Operating unit unique identifier
VARIANCE_ACCOUNT_ID	NUMBER			GL variance account unique identifier
PREVENT_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Indicates whether the distribution requires encumbrance or not
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
PROJECT_ID	NUMBER			Project accounting project unique identifier
TASK_ID	NUMBER			Project accounting task unique identifier
EXPENDITURE_TYPE	VARCHAR2	(30)		Project accounting expenditure type
PROJECT_ACCOUNTING_CONTEXT	VARCHAR2	(30)		Project accounting descriptive flexfield context column
EXPENDITURE_ORGANIZATION_ID	NUMBER			Project accounting expenditure organization unique identifier
GL_CLOSED_DATE	DATE			Date the distribution was final-closed
SOURCE_REQ_DISTRIBUTION_ID	NUMBER			Distribution unique identifier that indicates whether the distribution is encumbered when it is cancelled
DISTRIBUTION_NUM	NUMBER		Yes	Distribution number
PROJECT_RELATED_FLAG	VARCHAR2	(1)		Indicates whether the distribution is project related
EXPENDITURE_ITEM_DATE	DATE			Project accounting expenditure item date
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books unique identifier
ALLOCATION_TYPE	VARCHAR2	(25)		Specifies the method of allocation across distributions. Can be PERCENT
ALLOCATION_VALUE	NUMBER			Allocation split value
PERCENTAGE	NUMBER			Allocation Percentage
QUANTITY	NUMBER			Quantity
AMOUNT	NUMBER			Amount
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
RECOVERABLE_TAX	NUMBER			Recoverable tax
NONRECOVERABLE_TAX	NUMBER			Non recoverable tax
RECOVERY_RATE	NUMBER			Recovery Rate
TAX_RECOVERY_OVERRIDE_FLAG	VARCHAR2	(1)		Flag to indicate if the recovery rate was overriden

Query Text

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


SELECT DISTRIBUTION_ID
,      REQUISITION_LINE_ID
,      CODE_COMBINATION_ID
,      REQ_LINE_QUANTITY
,      ENCUMBERED_FLAG
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GL_CANCELLED_DATE
,      FAILED_FUNDS_LOOKUP_CODE
,      ENCUMBERED_AMOUNT
,      BUDGET_ACCOUNT_ID
,      ACCRUAL_ACCOUNT_ID
,      ORG_ID
,      VARIANCE_ACCOUNT_ID
,      PREVENT_ENCUMBRANCE_FLAG
,      USSGL_TRANSACTION_CODE
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION_ID
,      GL_CLOSED_DATE
,      SOURCE_REQ_DISTRIBUTION_ID
,      DISTRIBUTION_NUM
,      PROJECT_RELATED_FLAG
,      EXPENDITURE_ITEM_DATE
,      SET_OF_BOOKS_ID
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      PERCENTAGE
,      QUANTITY
,      AMOUNT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
FROM APPS.POR_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS.POR_DISTRIBUTIONS_V references the following:

APPS: PO_REQUISITION_LINES; PO_REQ_DISTRIBUTIONS

APPS.POR_DISTRIBUTIONS_V is not referenced by any database object