VIEW: APPS.PO_DISTRIBUTIONS_V

Source

View Text - Preformatted

SELECT POD1.ROWID , POD1.PO_DISTRIBUTION_ID , POD1.REQ_DISTRIBUTION_ID , DECODE(POD1.REQ_DISTRIBUTION_ID,NULL,'N','Y') , POD1.RATE_DATE , POD1.AMOUNT_BILLED , POD1.ENCUMBERED_AMOUNT , POD1.FAILED_FUNDS_LOOKUP_CODE , POD1.GL_ENCUMBERED_PERIOD_NAME , POD1.DESTINATION_ORGANIZATION_ID , POD1.WIP_ENTITY_ID , POD1.WIP_RESOURCE_SEQ_NUM , POD1.BOM_RESOURCE_ID , POD1.VARIANCE_ACCOUNT_ID , POD1.DESTINATION_CONTEXT , POD1.PROGRAM_APPLICATION_ID , POD1.GOVERNMENT_CONTEXT , POD1.USSGL_TRANSACTION_CODE , POD1.WIP_LINE_ID , POD1.PROJECT_ID , POD1.TASK_ID , POD1.EXPENDITURE_TYPE , POD1.PROJECT_ACCOUNTING_CONTEXT , POD1.EXPENDITURE_ORGANIZATION_ID , POD1.GL_CLOSED_DATE , POD1.ACCRUE_ON_RECEIPT_FLAG , POD1.EXPENDITURE_ITEM_DATE , POD1.LAST_UPDATED_BY , POD1.LINE_LOCATION_ID , POD1.QUANTITY_ORDERED , POD1.CREATION_DATE , NVL(POD1.QUANTITY_DELIVERED,0) , POD1.QUANTITY_CANCELLED , POD1.LAST_UPDATE_DATE , POD1.PO_HEADER_ID , POD1.PO_LINE_ID , POD1.SET_OF_BOOKS_ID , POD1.CODE_COMBINATION_ID , POD1.LAST_UPDATE_LOGIN , POD1.CREATED_BY , POD1.PO_RELEASE_ID , NVL(POD1.QUANTITY_BILLED,0) , decode(POD1.req_distribution_id, null, POD1.req_header_reference_num, PORH.segment1) , decode(POD1.req_distribution_id, null, POD1.REQ_LINE_REFERENCE_NUM,PORL.LINE_NUM) , POD1.DELIVER_TO_LOCATION_ID , POD1.DELIVER_TO_PERSON_ID , POD1.RATE , POD1.ACCRUED_FLAG , POD1.ENCUMBERED_FLAG , POD1.UNENCUMBERED_QUANTITY , POD1.UNENCUMBERED_AMOUNT , POD1.GL_ENCUMBERED_DATE , POD1.GL_CANCELLED_DATE , POD1.DESTINATION_TYPE_CODE , POD1.DESTINATION_SUBINVENTORY , POD1.ATTRIBUTE_CATEGORY , POD1.ATTRIBUTE1 , POD1.ATTRIBUTE2 , POD1.ATTRIBUTE3 , POD1.ATTRIBUTE4 , POD1.ATTRIBUTE5 , POD1.ATTRIBUTE6 , POD1.ATTRIBUTE7 , POD1.ATTRIBUTE8 , POD1.ATTRIBUTE9 , POD1.ATTRIBUTE10 , POD1.ATTRIBUTE11 , POD1.ATTRIBUTE12 , POD1.ATTRIBUTE13 , POD1.ATTRIBUTE14 , POD1.ATTRIBUTE15 , POD1.WIP_OPERATION_SEQ_NUM , POD1.WIP_REPETITIVE_SCHEDULE_ID , POD1.BUDGET_ACCOUNT_ID , POD1.ACCRUAL_ACCOUNT_ID , POD2.DISTRIBUTION_NUM , POD1.SOURCE_DISTRIBUTION_ID , POD1.DISTRIBUTION_NUM , POD1.REQUEST_ID , POD1.PROGRAM_ID , POD1.PROGRAM_UPDATE_DATE , POD1.PREVENT_ENCUMBRANCE_FLAG , PORL.REQUISITION_LINE_ID , PORH.REQUISITION_HEADER_ID , PORL.LINE_NUM , PORH.SEGMENT1 , POD1.END_ITEM_UNIT_NUMBER , POD1.RECOVERABLE_TAX , POD1.NONRECOVERABLE_TAX , POD1.RECOVERY_RATE , POD1.TAX_RECOVERY_OVERRIDE_FLAG , POD1.AWARD_ID , POD1.OKE_CONTRACT_LINE_ID , POD1.OKE_CONTRACT_DELIVERABLE_ID , POD1.AMOUNT_ORDERED , POD1.AMOUNT_DELIVERED , POD1.AMOUNT_CANCELLED , POD1.INVOICE_ADJUSTMENT_FLAG , POD1.AMOUNT_TO_ENCUMBER , POD1.DISTRIBUTION_TYPE , POD1.DEST_CHARGE_ACCOUNT_ID , POD1.DEST_VARIANCE_ACCOUNT_ID , PORH.ORG_ID , HOUT.NAME FROM PO_DISTRIBUTIONS_ALL POD2, PO_REQUISITION_HEADERS_ALL PORH, PO_REQUISITION_LINES_ALL PORL, PO_REQ_DISTRIBUTIONS_ALL PORD, PO_DISTRIBUTIONS POD1, HR_ALL_ORGANIZATION_UNITS_TL HOUT WHERE POD1.SOURCE_DISTRIBUTION_ID = POD2.PO_DISTRIBUTION_ID (+) and POD1.REQ_DISTRIBUTION_ID = PORD.DISTRIBUTION_ID (+) AND PORD.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID (+) AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID (+) AND PORH.ORG_ID = HOUT.ORGANIZATION_ID (+) AND HOUT.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT POD1.ROWID
, POD1.PO_DISTRIBUTION_ID
, POD1.REQ_DISTRIBUTION_ID
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, 'N'
, 'Y')
, POD1.RATE_DATE
, POD1.AMOUNT_BILLED
, POD1.ENCUMBERED_AMOUNT
, POD1.FAILED_FUNDS_LOOKUP_CODE
, POD1.GL_ENCUMBERED_PERIOD_NAME
, POD1.DESTINATION_ORGANIZATION_ID
, POD1.WIP_ENTITY_ID
, POD1.WIP_RESOURCE_SEQ_NUM
, POD1.BOM_RESOURCE_ID
, POD1.VARIANCE_ACCOUNT_ID
, POD1.DESTINATION_CONTEXT
, POD1.PROGRAM_APPLICATION_ID
, POD1.GOVERNMENT_CONTEXT
, POD1.USSGL_TRANSACTION_CODE
, POD1.WIP_LINE_ID
, POD1.PROJECT_ID
, POD1.TASK_ID
, POD1.EXPENDITURE_TYPE
, POD1.PROJECT_ACCOUNTING_CONTEXT
, POD1.EXPENDITURE_ORGANIZATION_ID
, POD1.GL_CLOSED_DATE
, POD1.ACCRUE_ON_RECEIPT_FLAG
, POD1.EXPENDITURE_ITEM_DATE
, POD1.LAST_UPDATED_BY
, POD1.LINE_LOCATION_ID
, POD1.QUANTITY_ORDERED
, POD1.CREATION_DATE
, NVL(POD1.QUANTITY_DELIVERED
, 0)
, POD1.QUANTITY_CANCELLED
, POD1.LAST_UPDATE_DATE
, POD1.PO_HEADER_ID
, POD1.PO_LINE_ID
, POD1.SET_OF_BOOKS_ID
, POD1.CODE_COMBINATION_ID
, POD1.LAST_UPDATE_LOGIN
, POD1.CREATED_BY
, POD1.PO_RELEASE_ID
, NVL(POD1.QUANTITY_BILLED
, 0)
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, POD1.REQ_HEADER_REFERENCE_NUM
, PORH.SEGMENT1)
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, POD1.REQ_LINE_REFERENCE_NUM
, PORL.LINE_NUM)
, POD1.DELIVER_TO_LOCATION_ID
, POD1.DELIVER_TO_PERSON_ID
, POD1.RATE
, POD1.ACCRUED_FLAG
, POD1.ENCUMBERED_FLAG
, POD1.UNENCUMBERED_QUANTITY
, POD1.UNENCUMBERED_AMOUNT
, POD1.GL_ENCUMBERED_DATE
, POD1.GL_CANCELLED_DATE
, POD1.DESTINATION_TYPE_CODE
, POD1.DESTINATION_SUBINVENTORY
, POD1.ATTRIBUTE_CATEGORY
, POD1.ATTRIBUTE1
, POD1.ATTRIBUTE2
, POD1.ATTRIBUTE3
, POD1.ATTRIBUTE4
, POD1.ATTRIBUTE5
, POD1.ATTRIBUTE6
, POD1.ATTRIBUTE7
, POD1.ATTRIBUTE8
, POD1.ATTRIBUTE9
, POD1.ATTRIBUTE10
, POD1.ATTRIBUTE11
, POD1.ATTRIBUTE12
, POD1.ATTRIBUTE13
, POD1.ATTRIBUTE14
, POD1.ATTRIBUTE15
, POD1.WIP_OPERATION_SEQ_NUM
, POD1.WIP_REPETITIVE_SCHEDULE_ID
, POD1.BUDGET_ACCOUNT_ID
, POD1.ACCRUAL_ACCOUNT_ID
, POD2.DISTRIBUTION_NUM
, POD1.SOURCE_DISTRIBUTION_ID
, POD1.DISTRIBUTION_NUM
, POD1.REQUEST_ID
, POD1.PROGRAM_ID
, POD1.PROGRAM_UPDATE_DATE
, POD1.PREVENT_ENCUMBRANCE_FLAG
, PORL.REQUISITION_LINE_ID
, PORH.REQUISITION_HEADER_ID
, PORL.LINE_NUM
, PORH.SEGMENT1
, POD1.END_ITEM_UNIT_NUMBER
, POD1.RECOVERABLE_TAX
, POD1.NONRECOVERABLE_TAX
, POD1.RECOVERY_RATE
, POD1.TAX_RECOVERY_OVERRIDE_FLAG
, POD1.AWARD_ID
, POD1.OKE_CONTRACT_LINE_ID
, POD1.OKE_CONTRACT_DELIVERABLE_ID
, POD1.AMOUNT_ORDERED
, POD1.AMOUNT_DELIVERED
, POD1.AMOUNT_CANCELLED
, POD1.INVOICE_ADJUSTMENT_FLAG
, POD1.AMOUNT_TO_ENCUMBER
, POD1.DISTRIBUTION_TYPE
, POD1.DEST_CHARGE_ACCOUNT_ID
, POD1.DEST_VARIANCE_ACCOUNT_ID
, PORH.ORG_ID
, HOUT.NAME
FROM PO_DISTRIBUTIONS_ALL POD2
, PO_REQUISITION_HEADERS_ALL PORH
, PO_REQUISITION_LINES_ALL PORL
, PO_REQ_DISTRIBUTIONS_ALL PORD
, PO_DISTRIBUTIONS POD1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
WHERE POD1.SOURCE_DISTRIBUTION_ID = POD2.PO_DISTRIBUTION_ID (+)
AND POD1.REQ_DISTRIBUTION_ID = PORD.DISTRIBUTION_ID (+)
AND PORD.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID (+)
AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID (+)
AND PORH.ORG_ID = HOUT.ORGANIZATION_ID (+)
AND HOUT.LANGUAGE (+) = USERENV('LANG')