FND Design Data [Home] [Help]

View: POBV_REQUISITION_DISTRIBUTIONS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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

Name
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
SET_OF_BOOKS_ID
CHARGE_ACCOUNT_ID
BUDGET_ACCOUNT_ID
ACCRUAL_ACCOUNT_ID
VARIANCE_ACCOUNT_ID
PROJECT_ID
TASK_ID
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_OVERRIDE_FG"
OKE_CONTRACT_LINE_ID
OKE_CONTRACT_DELIVERABLE_ID
DROP_SHIP_FLAG
REQ_LINE_AMOUNT
REQ_LINE_CURRENCY_AMOUNT