PO_DISTRIBUTIONS_AP_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

PO_DISTRIBUTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LINE_LOCATION_ID SET_OF_BOOKS_ID CODE_COMBINATION_ID QUANTITY_ORDERED LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PO_RELEASE_ID QUANTITY_DELIVERED QUANTITY_BILLED QUANTITY_CANCELLED REQ_HEADER_REFERENCE_NUM REQ_LINE_REFERENCE_NUM REQ_DISTRIBUTION_ID DELIVER_TO_LOCATION_ID DELIVER_TO_PERSON_ID RATE_DATE RATE AMOUNT_BILLED ACCRUED_FLAG ENCUMBERED_FLAG ENCUMBERED_AMOUNT UNENCUMBERED_QUANTITY UNENCUMBERED_AMOUNT FAILED_FUNDS_LOOKUP_CODE GL_ENCUMBERED_DATE GL_ENCUMBERED_PERIOD_NAME GL_CANCELLED_DATE DESTINATION_TYPE_CODE DESTINATION_ORGANIZATION_ID DESTINATION_SUBINVENTORY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 WIP_ENTITY_ID WIP_OPERATION_SEQ_NUM WIP_RESOURCE_SEQ_NUM WIP_REPETITIVE_SCHEDULE_ID WIP_LINE_ID BOM_RESOURCE_ID ORIGINAL_CHARGE_ACCOUNT_ID BUDGET_ACCOUNT_ID ACCRUAL_ACCOUNT_ID VARIANCE_ACCOUNT_ID DESTINATION_CONTEXT SOURCE_DISTRIBUTION_ID DISTRIBUTION_NUM REQUEST_ID GOVERNMENT_CONTEXT REVERSE_ENCUMBRANCE_FLAG ACCRUE_ON_RECEIPT_FLAG AWARD_ID AMOUNT_ORDERED AMOUNT_DELIVERED AMOUNT_CANCELLED INVOICE_ADJUSTMENT_FLAG RECOVERY_RATE SOLDTO_BU_ID DISTRIBUTION_TYPE QUANTITY_FINANCED AMOUNT_FINANCED QUANTITY_RECOUPED AMOUNT_RECOUPED RETAINAGE_WITHHELD_AMOUNT RETAINAGE_RELEASED_AMOUNT PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 PJC_CONTRACT_ID PJC_WORK_TYPE_ID PJC_CAPITALIZABLE_FLAG PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_FUNDING_ALLOCATION_ID PJC_CONTRACT_LINE_ID PJC_CONTEXT_CATEGORY PJC_EXPENDITURE_TYPE_ID PJC_BILLABLE_FLAG PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID

Query

SQL_Statement

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) CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.LAST_UPDATE_LOGIN, POD.CREATION_DATE, POD.CREATED_BY, null 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 ORIGINAL_CHARGE_ACCOUNT_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.GOVERNMENT_CONTEXT, DECODE(PREVENT_ENCUMBRANCE_FLAG, 'Y', 'N', (DECODE(POD.ACCRUE_ON_RECEIPT_FLAG, 'Y', 'N', 'Y'))) REVERSE_ENCUMBRANCE_FLAG, NVL(POD.ACCRUE_ON_RECEIPT_FLAG, 'N') ACCRUE_ON_RECEIPT_FLAG, POD.AWARD_ID, POD.AMOUNT_ORDERED, POD.AMOUNT_DELIVERED, POD.AMOUNT_CANCELLED, POD.INVOICE_ADJUSTMENT_FLAG, POD.RECOVERY_RATE, POD.SOLDTO_BU_ID, POD.DISTRIBUTION_TYPE, POD.QUANTITY_FINANCED, POD.AMOUNT_FINANCED, POD.QUANTITY_RECOUPED, POD.AMOUNT_RECOUPED, POD.RETAINAGE_WITHHELD_AMOUNT, POD.RETAINAGE_RELEASED_AMOUNT, POD.PJC_USER_DEF_ATTRIBUTE1, POD.PJC_USER_DEF_ATTRIBUTE2, POD.PJC_USER_DEF_ATTRIBUTE3, POD.PJC_USER_DEF_ATTRIBUTE4, POD.PJC_USER_DEF_ATTRIBUTE5, POD.PJC_USER_DEF_ATTRIBUTE6, POD.PJC_USER_DEF_ATTRIBUTE7, POD.PJC_USER_DEF_ATTRIBUTE8, POD.PJC_USER_DEF_ATTRIBUTE9, POD.PJC_USER_DEF_ATTRIBUTE10, POD.PJC_CONTRACT_ID, POD.PJC_WORK_TYPE_ID, POD.PJC_CAPITALIZABLE_FLAG, POD.PJC_RESERVED_ATTRIBUTE1, POD.PJC_RESERVED_ATTRIBUTE2, POD.PJC_RESERVED_ATTRIBUTE3, POD.PJC_RESERVED_ATTRIBUTE4, POD.PJC_RESERVED_ATTRIBUTE5, POD.PJC_RESERVED_ATTRIBUTE6, POD.PJC_RESERVED_ATTRIBUTE7, POD.PJC_RESERVED_ATTRIBUTE8, POD.PJC_RESERVED_ATTRIBUTE9, POD.PJC_RESERVED_ATTRIBUTE10, POD.PJC_FUNDING_ALLOCATION_ID, POD.PJC_CONTRACT_LINE_ID, POD.PJC_CONTEXT_CATEGORY, POD.PJC_EXPENDITURE_TYPE_ID, POD.PJC_BILLABLE_FLAG, POD.PJC_PROJECT_ID, POD.PJC_TASK_ID, POD.PJC_EXPENDITURE_ITEM_DATE, POD.PJC_ORGANIZATION_ID FROM PO_DISTRIBUTIONS_ALL POD WHERE POD.LINE_LOCATION_ID IS NOT NULL