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_ALL_V

Object Details

Object Name:	POR_DISTRIBUTIONS_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_DISTRIBUTIONS_ALL_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. This view goes across operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRIBUTION_ID	NUMBER		Yes	Requisition distribution unique identifier
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
CODE_COMBINATION_ID	NUMBER		Yes	Unique identifier for the General Ledger charge account
REQ_LINE_QUANTITY	NUMBER			Quantity for the distribution
ENCUMBERED_FLAG	VARCHAR2	(1)		Indicates whether the distribution is encumbered or not
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			Unique identifier for the General Ledger budget account
ACCRUAL_ACCOUNT_ID	NUMBER			Unique identifier for the General Ledger accrual account
ORG_ID	NUMBER			Operating unit unique identifier
VARIANCE_ACCOUNT_ID	NUMBER			Unique identifier for the General Ledger variance account
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)		Allocation type
ALLOCATION_VALUE	NUMBER			Allocation value
PERCENTAGE	NUMBER			Allocation percentage
QUANTITY	NUMBER			Quantity
AMOUNT	NUMBER			Amount
ATTRIBUTE1	VARCHAR2	(150)		Attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Attribute 15

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
FROM APPS.POR_DISTRIBUTIONS_ALL_V;

Dependencies

[top of page]

APPS.POR_DISTRIBUTIONS_ALL_V references the following:

APPS: PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL

APPS.POR_DISTRIBUTIONS_ALL_V is not referenced by any database object