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

Object Details

Object Name:	POFV_REQUISITION_DISTRIBUTIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_REQUISITION_DISTRIBUTIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows accounting distribution information for a requisition line.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_DISTRIBUTION_ID	NUMBER		Yes
DISTRIBUTION_NUMBER	NUMBER		Yes
REQUISITION_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
REQUISITION_ID	NUMBER		Yes
REQUISITION_DOCUMENT_NUMBER	VARCHAR2	(20)	Yes
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
DISTRIBUTION_QUANTITY	NUMBER
GL_CANCELLED_DATE	DATE
GL_CLOSED_DATE	DATE
_LA:PREVENT_ENCUMBRANCE_FLAG	CHAR	(70)
_LA:ENCUMBERED_FLAG	CHAR	(61)
ENCUMBERED_AMOUNT	NUMBER
GL_ENCUMBERED_DATE	DATE
GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)
_LA:FUNDS_CHECK_FAILURE_TYPE	CHAR	(74)
_LA:PROJECT_RELATED_FLAG	CHAR	(66)
PROJECT_EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_ITEM_DATE	DATE
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
_DF	CHAR	(30)
SET_OF_BOOKS_ID	NUMBER		Yes
SET_OF_BOOKS_NAME	VARCHAR2	(30)	Yes
CHARGE_ACCOUNT_ID	NUMBER		Yes
_KF:ACCOUNT_NUM:CHARGE:_CO	CHAR	(16)
BUDGET_ACCOUNT_ID	NUMBER
_KF:ACCOUNT_NUM:BUDGET:_CO	CHAR	(16)
ACCRUAL_ACCOUNT_ID	NUMBER
_KF:ACCOUNT_NUM:ACCRUAL:_CO	CHAR	(16)
VARIANCE_ACCOUNT_ID	NUMBER
_KF:ACCOUNT_NUM:VARIANCE:_CO	CHAR	(16)
PROJECT_ID	NUMBER
PROJECT_NAME	VARCHAR2	(30)
TASK_ID	NUMBER
TASK_NUMBER	VARCHAR2	(25)
CREATED_DATE	DATE
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ALLOCATION_TYPE	VARCHAR2	(25)
ALLOCATION_VALUE	NUMBER
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
RECOVERABLE_TAX	NUMBER
NONRECOVERABLE_TAX	NUMBER
RECOVERY_RATE	NUMBER
_LA:TAX_RECOVERY_OVER_FLAG	CHAR	(72)
OKE_CONTRACT_LINE_ID	NUMBER
OKE_CONTRACT_DELIVERABLE_ID	NUMBER
OKE_CONTRACT_LINE_NUM	VARCHAR2	(150)
OKE_CONTRACT_DELIVERABLE_NUM	VARCHAR2	(150)
DROP_SHIP_FLAG	VARCHAR2	(1)		Indicates whether the Shipment has a backing Sales Order Line.
REQ_LINE_AMOUNT	NUMBER			Amount on the req line
REQ_LINE_CURRENCY_AMOUNT	NUMBER			Foreign Currency Amount on the requisition distribution

Query Text

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


SELECT REQUISITION_DISTRIBUTION_ID
,      DISTRIBUTION_NUMBER
,      REQUISITION_LINE_ID
,      LINE_NUMBER
,      REQUISITION_ID
,      REQUISITION_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      DISTRIBUTION_QUANTITY
,      GL_CANCELLED_DATE
,      GL_CLOSED_DATE
,      _LA:PREVENT_ENCUMBRANCE_FLAG
,      _LA:ENCUMBERED_FLAG
,      ENCUMBERED_AMOUNT
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      _LA:FUNDS_CHECK_FAILURE_TYPE
,      _LA:PROJECT_RELATED_FLAG
,      PROJECT_EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      USSGL_TRANSACTION_CODE
,      _DF
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      CHARGE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:CHARGE:_CO
,      BUDGET_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:BUDGET:_CO
,      ACCRUAL_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:ACCRUAL:_CO
,      VARIANCE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:VARIANCE:_CO
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      ALLOCATION_TYPE
,      ALLOCATION_VALUE
,      END_ITEM_UNIT_NUMBER
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      RECOVERY_RATE
,      _LA:TAX_RECOVERY_OVER_FLAG
,      OKE_CONTRACT_LINE_ID
,      OKE_CONTRACT_DELIVERABLE_ID
,      OKE_CONTRACT_LINE_NUM
,      OKE_CONTRACT_DELIVERABLE_NUM
,      DROP_SHIP_FLAG
,      REQ_LINE_AMOUNT
,      REQ_LINE_CURRENCY_AMOUNT
FROM APPS.POFV_REQUISITION_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.POFV_REQUISITION_DISTRIBUTIONS references the following:

APPS: GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS; OKC_K_LINES_B; OKE_K_DELIVERABLES_B; PA_PROJECTS_ALL; PA_TASKS; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL

APPS.POFV_REQUISITION_DISTRIBUTIONS is not referenced by any database object