VIEW: APPS.PO_DISTRIBUTIONS_AP_V

Source

View Text - Preformatted

SELECT POD.PO_DISTRIBUTION_ID , POD.LAST_UPDATE_DATE , POD.LAST_UPDATED_BY , POD.PO_HEADER_ID , POD.PO_LINE_ID , POD.LINE_LOCATION_ID , POD.SET_OF_BOOKS_ID , decode(POD.DESTINATION_TYPE_CODE, 'EXPENSE',decode(POD.ACCRUE_ON_RECEIPT_FLAG, 'Y',POD.ACCRUAL_ACCOUNT_ID, POD.CODE_COMBINATION_ID), POD.ACCRUAL_ACCOUNT_ID) , POD.QUANTITY_ORDERED , POD.LAST_UPDATE_LOGIN , POD.CREATION_DATE , POD.CREATED_BY , POD.PO_RELEASE_ID , POD.QUANTITY_DELIVERED , POD.QUANTITY_BILLED , POD.QUANTITY_CANCELLED , POD.REQ_HEADER_REFERENCE_NUM , POD.REQ_LINE_REFERENCE_NUM , POD.REQ_DISTRIBUTION_ID , POD.DELIVER_TO_LOCATION_ID , POD.DELIVER_TO_PERSON_ID , POD.RATE_DATE , POD.RATE , POD.AMOUNT_BILLED , POD.ACCRUED_FLAG , POD.ENCUMBERED_FLAG , POD.ENCUMBERED_AMOUNT , POD.UNENCUMBERED_QUANTITY , POD.UNENCUMBERED_AMOUNT , POD.FAILED_FUNDS_LOOKUP_CODE , POD.GL_ENCUMBERED_DATE , POD.GL_ENCUMBERED_PERIOD_NAME , POD.GL_CANCELLED_DATE , POD.DESTINATION_TYPE_CODE , POD.DESTINATION_ORGANIZATION_ID , POD.DESTINATION_SUBINVENTORY , POD.ATTRIBUTE_CATEGORY , POD.ATTRIBUTE1 , POD.ATTRIBUTE2 , POD.ATTRIBUTE3 , POD.ATTRIBUTE4 , POD.ATTRIBUTE5 , POD.ATTRIBUTE6 , POD.ATTRIBUTE7 , POD.ATTRIBUTE8 , POD.ATTRIBUTE9 , POD.ATTRIBUTE10 , POD.ATTRIBUTE11 , POD.ATTRIBUTE12 , POD.ATTRIBUTE13 , POD.ATTRIBUTE14 , POD.ATTRIBUTE15 , POD.WIP_ENTITY_ID , POD.WIP_OPERATION_SEQ_NUM , POD.WIP_RESOURCE_SEQ_NUM , POD.WIP_REPETITIVE_SCHEDULE_ID , POD.WIP_LINE_ID , POD.BOM_RESOURCE_ID , POD.CODE_COMBINATION_ID , POD.BUDGET_ACCOUNT_ID , POD.ACCRUAL_ACCOUNT_ID , POD.VARIANCE_ACCOUNT_ID , POD.DESTINATION_CONTEXT , POD.SOURCE_DISTRIBUTION_ID , POD.DISTRIBUTION_NUM , POD.REQUEST_ID , POD.PROGRAM_APPLICATION_ID , POD.PROGRAM_ID , POD.PROGRAM_UPDATE_DATE , POD.GOVERNMENT_CONTEXT , decode(prevent_encumbrance_flag,'Y','N', decode(pod.accrue_on_receipt_flag,'Y','N', 'Y')) , POD.USSGL_TRANSACTION_CODE , POD.PROJECT_ID , POD.TASK_ID , POD.EXPENDITURE_TYPE , POD.PROJECT_ACCOUNTING_CONTEXT , POD.EXPENDITURE_ORGANIZATION_ID , POD.EXPENDITURE_ITEM_DATE , nvl(POD.accrue_on_receipt_flag, 'N') , POD.AWARD_ID , POD.AMOUNT_ORDERED , POD.AMOUNT_DELIVERED , POD.AMOUNT_CANCELLED , POD.INVOICE_ADJUSTMENT_FLAG , POD.RECOVERY_RATE , POD.ORG_ID , POD.DISTRIBUTION_TYPE , POD.QUANTITY_FINANCED , POD.AMOUNT_FINANCED , POD.QUANTITY_RECOUPED , POD.AMOUNT_RECOUPED , POD.RETAINAGE_WITHHELD_AMOUNT , POD.RETAINAGE_RELEASED_AMOUNT FROM PO_DISTRIBUTIONS POD  WHERE POD.line_location_id IS NOT NULL

View Text - HTML Formatted

SELECT POD.PO_DISTRIBUTION_ID
, POD.LAST_UPDATE_DATE
, POD.LAST_UPDATED_BY
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.SET_OF_BOOKS_ID
, DECODE(POD.DESTINATION_TYPE_CODE
, 'EXPENSE'
, DECODE(POD.ACCRUE_ON_RECEIPT_FLAG
, 'Y'
, POD.ACCRUAL_ACCOUNT_ID
, POD.CODE_COMBINATION_ID)
, POD.ACCRUAL_ACCOUNT_ID)
, POD.QUANTITY_ORDERED
, POD.LAST_UPDATE_LOGIN
, POD.CREATION_DATE
, POD.CREATED_BY
, POD.PO_RELEASE_ID
, POD.QUANTITY_DELIVERED
, POD.QUANTITY_BILLED
, POD.QUANTITY_CANCELLED
, POD.REQ_HEADER_REFERENCE_NUM
, POD.REQ_LINE_REFERENCE_NUM
, POD.REQ_DISTRIBUTION_ID
, POD.DELIVER_TO_LOCATION_ID
, POD.DELIVER_TO_PERSON_ID
, POD.RATE_DATE
, POD.RATE
, POD.AMOUNT_BILLED
, POD.ACCRUED_FLAG
, POD.ENCUMBERED_FLAG
, POD.ENCUMBERED_AMOUNT
, POD.UNENCUMBERED_QUANTITY
, POD.UNENCUMBERED_AMOUNT
, POD.FAILED_FUNDS_LOOKUP_CODE
, POD.GL_ENCUMBERED_DATE
, POD.GL_ENCUMBERED_PERIOD_NAME
, POD.GL_CANCELLED_DATE
, POD.DESTINATION_TYPE_CODE
, POD.DESTINATION_ORGANIZATION_ID
, POD.DESTINATION_SUBINVENTORY
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, POD.WIP_ENTITY_ID
, POD.WIP_OPERATION_SEQ_NUM
, POD.WIP_RESOURCE_SEQ_NUM
, POD.WIP_REPETITIVE_SCHEDULE_ID
, POD.WIP_LINE_ID
, POD.BOM_RESOURCE_ID
, POD.CODE_COMBINATION_ID
, POD.BUDGET_ACCOUNT_ID
, POD.ACCRUAL_ACCOUNT_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.DESTINATION_CONTEXT
, POD.SOURCE_DISTRIBUTION_ID
, POD.DISTRIBUTION_NUM
, POD.REQUEST_ID
, POD.PROGRAM_APPLICATION_ID
, POD.PROGRAM_ID
, POD.PROGRAM_UPDATE_DATE
, POD.GOVERNMENT_CONTEXT
, DECODE(PREVENT_ENCUMBRANCE_FLAG
, 'Y'
, 'N'
, DECODE(POD.ACCRUE_ON_RECEIPT_FLAG
, 'Y'
, 'N'
, 'Y'))
, POD.USSGL_TRANSACTION_CODE
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.PROJECT_ACCOUNTING_CONTEXT
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.EXPENDITURE_ITEM_DATE
, NVL(POD.ACCRUE_ON_RECEIPT_FLAG
, 'N')
, POD.AWARD_ID
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.RECOVERY_RATE
, POD.ORG_ID
, POD.DISTRIBUTION_TYPE
, POD.QUANTITY_FINANCED
, POD.AMOUNT_FINANCED
, POD.QUANTITY_RECOUPED
, POD.AMOUNT_RECOUPED
, POD.RETAINAGE_WITHHELD_AMOUNT
, POD.RETAINAGE_RELEASED_AMOUNT
FROM PO_DISTRIBUTIONS POD
WHERE POD.LINE_LOCATION_ID IS NOT NULL