VIEW: APPS.POBV_REQUISITION_DISTRIBUTIONS

Source

View Text - Preformatted

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 WITH READ ONLY

View Text - HTML Formatted

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 WITH READ ONLY