View: POBV_REQUISITION_DISTRIBUTIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_REQUISITION_DISTRIBUTIONS

View Text

SELECT RD.DISTRIBUTION_ID
, RD.DISTRIBUTION_NUM
, RD.REQUISITION_LINE_ID
, RL.LINE_NUM
, RL.REQUISITION_HEADER_ID
, RH.SEGMENT1
, RD.ORG_ID
, OP.NAME
, RD.REQ_LINE_QUANTITY
, RD.GL_CANCELLED_DATE
, RD.GL_CLOSED_DATE
, '_LA:RD.PREVENT_ENCUMBRANCE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RD.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RD.ENCUMBERED_AMOUNT
, RD.GL_ENCUMBERED_DATE
, RD.GL_ENCUMBERED_PERIOD_NAME
, '_LA:RD.FAILED_FUNDS_LOOKUP_CODE:GL_LOOKUPS:FUNDS_CHECK_RETURN_CODE:MEANING'
, '_LA:RD.PROJECT_RELATED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RD.EXPENDITURE_TYPE
, RD.EXPENDITURE_ITEM_DATE
, RD.USSGL_TRANSACTION_CODE
, RD.SET_OF_BOOKS_ID
, RD.CODE_COMBINATION_ID
, RD.BUDGET_ACCOUNT_ID
, RD.ACCRUAL_ACCOUNT_ID
, RD.VARIANCE_ACCOUNT_ID
, RD.PROJECT_ID
, RD.TASK_ID
, RD.CREATION_DATE
, RD.CREATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATED_BY
, RD.ALLOCATION_TYPE
, RD.ALLOCATION_VALUE
, RD.END_ITEM_UNIT_NUMBER
, RD.RECOVERABLE_TAX
, RD.NONRECOVERABLE_TAX
, RD.RECOVERY_RATE
, '_LA:RD.TAX_RECOVERY_OVERRIDE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RD.OKE_CONTRACT_LINE_ID
, RD.OKE_CONTRACT_DELIVERABLE_ID
, RL.DROP_SHIP_FLAG
, RD.REQ_LINE_AMOUNT
, RD.REQ_LINE_CURRENCY_AMOUNT
FROM PO_REQ_DISTRIBUTIONS_ALL RD
, PO_REQUISITION_LINES_ALL RL
, PO_REQUISITION_HEADERS_ALL RH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE RD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID
AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
AND RD.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:RD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns