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]

TABLE: PO.PO_REQ_DISTRIBUTIONS_ALL

Object Details

Object Name:	PO_REQ_DISTRIBUTIONS_ALL
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_REQ_DISTRIBUTIONS_ALL
Subobject Name:
Status:	VALID

PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting
distributions associated with each requisition line. Each
requisition line must have at least one accounting distribution.
You need one row for each requisition distribution you create.
Each row includes the Accounting Flexfield ID and requisition line
quantity.
.
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your
requisition information. This table corresponds to the requisition
Distributions window, accessible through the Requisitions window.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_REQ_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID
PO_REQ_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUISITION_LINE_ID
PO_REQ_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_ENCUMBERED_DATE
PO_REQ_DISTRIBUTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_REQ_DISTRIBUTION_ID
PO_REQ_DISTRIBUTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
PO_REQ_DISTRIBUTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_ACCOUNT_ID
PO_REQ_DISTRIBUTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRIBUTION_ID	NUMBER		Yes	Requisition distribution unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
SET_OF_BOOKS_ID	NUMBER		Yes	Set of Books unique identifier
CODE_COMBINATION_ID	NUMBER		Yes	Unique identifier for the General Ledger charge account
REQ_LINE_QUANTITY	NUMBER			Quantity for the distribution
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
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
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROJECT_ID	NUMBER			Project accounting project unique identifier
TASK_ID	NUMBER			Project accounting task unique identifier
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Project Manufacturing end item unit number
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
ALLOCATION_TYPE	VARCHAR2	(25)		Method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE	NUMBER			Allocation split value
PROJECT_RELATED_FLAG	VARCHAR2	(1)		Indicates whether the distribution is project related
EXPENDITURE_ITEM_DATE	DATE			Project accounting expenditure item date
ORG_ID	NUMBER			Organization identifier
AWARD_ID	NUMBER	(15)		Award identifier
RECOVERABLE_TAX	NUMBER			Recoverable tax amount
NONRECOVERABLE_TAX	NUMBER			Nonrecoverable tax amount
RECOVERY_RATE	NUMBER			Percentage of tax that can be recovered
TAX_RECOVERY_OVERRIDE_FLAG	VARCHAR2	(1)		Indicator of whether tax recovery should be used
OKE_CONTRACT_LINE_ID	NUMBER			Stores the line id of a contract
OKE_CONTRACT_DELIVERABLE_ID	NUMBER			Stores the deliverable id corresponding to the contract
REQ_LINE_AMOUNT	NUMBER			Amount on the req line
REQ_LINE_CURRENCY_AMOUNT	NUMBER			Foreign Currency Amount on the requisition distribution
REQ_AWARD_ID	NUMBER	(15)		Award ID corresponding to the award on the requisition distribution. References GMS_AWARDS_ALL.award_id.
EVENT_ID	NUMBER			Keeps track of latest SLA event
CONFORMED_DIST_ID	NUMBER			Populated only for Amendment records and stores the distribution_id of the parent distribution
AMENDMENT_TYPE	VARCHAR2	(30)		Used for PR Amendment and shows the type of change. Possible values are ADDED, CHANGED, CANCELLED
AMENDMENT_STATUS	VARCHAR2	(3)		Used for PR Amendment and stores the amendment status. Possible values are N - New, A - Accepted, R - Rejected, P - Pending
UDA_TEMPLATE_ID	NUMBER			Uda Template Id
INFO_LINE_ID	NUMBER			Stores the requisition_line_id of the parent line for DOD structure
AMOUNT_FUNDED	NUMBER			Stores the total amount funded against this distribution
FUNDED_VALUE	NUMBER			Stores the funded value
PARTIAL_FUNDED_FLAG	VARCHAR2	(1)		States whether this line is partially funded or fully funded
QUANTITY_FUNDED	NUMBER			Stores the total quantity funded against this distribution
CLM_MISC_LOA	VARCHAR2	(200)		States whether this distribution belongs to the Line Of Accounting
CLM_DEFENCE_FUNDING	VARCHAR2	(10)		State whether this distribution is for defence funding
CLM_FMS_CASE_NUMBER	VARCHAR2	(240)		Case number for CLM FMS.
CLM_AGENCY_ACCT_IDENTIFIER	VARCHAR2	(1000)		The Agency Account identifier.
CHANGE_IN_FUNDED_VALUE	NUMBER			The change in the funded value.
UNENCUMBERED_AMOUNT	NUMBER			Amount that is unencumbered.
FUNDS_LIQUIDATED	NUMBER			Funds Liquidated
ACRN	VARCHAR2	(2)
PAR_DISTRIBUTION_ID	NUMBER
PAR_DRAFT_ID	NUMBER

Query Text

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


SELECT DISTRIBUTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUISITION_LINE_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      REQ_LINE_QUANTITY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ENCUMBERED_FLAG
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      GL_CANCELLED_DATE
,      FAILED_FUNDS_LOOKUP_CODE
,      ENCUMBERED_AMOUNT
,      BUDGET_ACCOUNT_ID
,      ACCRUAL_ACCOUNT_ID
,      VARIANCE_ACCOUNT_ID
,      PREVENT_ENCUMBRANCE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      EXPENDITURE_TYPE
,      PROJECT_ACCOUNTING_CONTEXT
,      EXPENDITURE_ORGANIZATION_ID
,      GL_CLOSED_DATE
,      SOURCE_REQ_DISTRIBUTION_ID
,      DISTRIBUTION_NUM
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      PROJECT_RELATED_FLAG
,      EXPENDITURE_ITEM_DATE
,      ORG_ID
,      AWARD_ID
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_DELIVERABLE_ID
,      REQ_LINE_AMOUNT
,      REQ_LINE_CURRENCY_AMOUNT
,      REQ_AWARD_ID
,      EVENT_ID
,      CONFORMED_DIST_ID
,      AMENDMENT_TYPE
,      AMENDMENT_STATUS
,      UDA_TEMPLATE_ID
,      INFO_LINE_ID
,      AMOUNT_FUNDED
,      FUNDED_VALUE
,      PARTIAL_FUNDED_FLAG
,      QUANTITY_FUNDED
,      CLM_MISC_LOA
,      CLM_DEFENCE_FUNDING
,      CLM_FMS_CASE_NUMBER
,      CLM_AGENCY_ACCT_IDENTIFIER
,      CHANGE_IN_FUNDED_VALUE
,      UNENCUMBERED_AMOUNT
,      FUNDS_LIQUIDATED
,      ACRN
,      PAR_DISTRIBUTION_ID
,      PAR_DRAFT_ID
FROM PO.PO_REQ_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

PO.PO_REQ_DISTRIBUTIONS_ALL does not reference any database object

PO.PO_REQ_DISTRIBUTIONS_ALL is referenced by following:

PO: PO_REQ_DISTRIBUTIONS_ALL#