View: POFV_REQUISITION_DISTRIBUTIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_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
, '_DF:PO:PO_REQ_DISTRIBUTIONS:RD'
, RD.SET_OF_BOOKS_ID
, SB.NAME
, RD.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:CC'
, RD.BUDGET_ACCOUNT_ID
, '_KF:SQLGL:GL#:BC'
, RD.ACCRUAL_ACCOUNT_ID
, '_KF:SQLGL:GL#:AC'
, RD.VARIANCE_ACCOUNT_ID
, '_KF:SQLGL:GL#:VC'
, RD.PROJECT_ID
, PJ.NAME
, RD.TASK_ID
, TK.TASK_NUMBER
, 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
, OKL.LINE_NUMBER
, OKD.DELIVERABLE_NUM
, 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
, GL_SETS_OF_BOOKS SB
, GL_CODE_COMBINATIONS CC
, GL_CODE_COMBINATIONS BC
, GL_CODE_COMBINATIONS AC
, GL_CODE_COMBINATIONS VC
, PA_PROJECTS_ALL PJ
, PA_TASKS TK
, OKC_K_LINES_B OKL
, OKE_K_DELIVERABLES_B OKD
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 RD.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND RD.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND RD.BUDGET_ACCOUNT_ID = BC.CODE_COMBINATION_ID(+)
AND RD.ACCRUAL_ACCOUNT_ID = AC.CODE_COMBINATION_ID(+)
AND RD.VARIANCE_ACCOUNT_ID = VC.CODE_COMBINATION_ID(+)
AND RD.PROJECT_ID = PJ.PROJECT_ID(+)
AND RD.TASK_ID = TK.TASK_ID(+)
AND RD.OKE_CONTRACT_LINE_ID = OKL.ID(+)
AND RD.OKE_CONTRACT_DELIVERABLE_ID = OKD.DELIVERABLE_ID(+)
AND '_SEC:RD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns