VIEW: APPS.POFV_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, '_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(+) 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
, '_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(+) WITH READ ONLY