eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PO_DISTRIBUTIONS_MERGE_V

Source

View Text - Preformatted


SELECT dft.owner_user_id, dft.owner_role, dft.status, dft.draft_id, podd.change_accepted_flag, podd.delete_flag, podd.destination_context, podd.distribution_num, podd.source_distribution_id, podd.request_id, podd.program_application_id, podd.program_id, podd.program_update_date, podd.project_id, podd.task_id, podd.expenditure_type, podd.project_accounting_context, podd.expenditure_organization_id, podd.gl_closed_date, podd.accrue_on_receipt_flag, podd.expenditure_item_date, podd.org_id, podd.gl_encumbered_period_name, podd.gl_cancelled_date, podd.destination_type_code, podd.destination_organization_id, podd.destination_subinventory, podd.attribute_category, podd.attribute1, podd.attribute2, podd.attribute3, podd.attribute4, podd.attribute5, podd.attribute6, podd.attribute7, podd.attribute8, podd.attribute9, podd.attribute10, podd.attribute11, podd.attribute12, podd.attribute13, podd.attribute14, podd.attribute15, podd.wip_entity_id, podd.wip_operation_seq_num, podd.wip_resource_seq_num, podd.wip_repetitive_schedule_id, podd.wip_line_id, podd.bom_resource_id, podd.budget_account_id, podd.accrual_account_id, podd.variance_account_id, podd.prevent_encumbrance_flag, podd.ussgl_transaction_code, podd.government_context, podd.po_distribution_id, podd.last_update_date, podd.last_updated_by, podd.po_header_id, podd.po_line_id, podd.line_location_id, podd.set_of_books_id, podd.code_combination_id, podd.quantity_ordered, podd.last_update_login, podd.creation_date, podd.created_by, podd.po_release_id, podd.quantity_delivered, podd.quantity_billed, podd.quantity_cancelled, podd.req_header_reference_num, podd.req_line_reference_num, podd.req_distribution_id, podd.deliver_to_location_id, podd.deliver_to_person_id, podd.rate_date, podd.rate, podd.amount_billed, podd.accrued_flag, podd.encumbered_flag, podd.encumbered_amount, podd.unencumbered_quantity, podd.unencumbered_amount, podd.failed_funds_lookup_code, podd.gl_encumbered_date, podd.kanban_card_id, podd.end_item_unit_number, podd.award_id, podd.mrc_rate_date, podd.mrc_rate, podd.mrc_encumbered_amount, podd.mrc_unencumbered_amount, podd.recoverable_tax, podd.nonrecoverable_tax, podd.recovery_rate, podd.tax_recovery_override_flag, podd.oke_contract_line_id, podd.oke_contract_deliverable_id, podd.amount_ordered, podd.amount_delivered, podd.amount_cancelled, podd.distribution_type, podd.amount_to_encumber, podd.invoice_adjustment_flag, podd.dest_charge_account_id, podd.dest_variance_account_id, podd.quantity_financed, podd.amount_financed, podd.quantity_recouped, podd.amount_recouped, podd.retainage_withheld_amount, podd.retainage_released_amount, podd.tax_attribute_update_code, podd.group_line_id, podd.change_status, podd.uda_template_id, podd.partial_funded_flag, podd.funded_value, podd.quantity_funded, podd.amount_funded, podd.clm_misc_loa, podd.clm_defence_funding, podd.clm_fms_case_number, podd.clm_agency_acct_identifier, podd.change_in_funded_value, podd.old_quantity_ordered, podd.acrn, podd.old_amount_ordered, podd.comments, podd.clm_payment_sequence_num, podd.par_draft_id, podd.par_distribution_id, NVL(podd.amount_changed_flag, 'N') FROM PO_DISTRIBUTIONS_DRAFT_ALL PODD,PO_DRAFTS DFT WHERE podd.draft_id = dft.draft_id AND Nvl(podd.delete_flag,'N') = 'N' UNION ALL SELECT To_number(NULL), NULL, NULL, To_number(-1), NULL, NULL, pod.destination_context, pod.distribution_num, pod.source_distribution_id, pod.request_id, pod.program_application_id, pod.program_id, pod.program_update_date, pod.project_id, pod.task_id, pod.expenditure_type, pod.project_accounting_context, pod.expenditure_organization_id, pod.gl_closed_date, pod.accrue_on_receipt_flag, pod.expenditure_item_date, pod.org_id, 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.budget_account_id, pod.accrual_account_id, pod.variance_account_id, pod.prevent_encumbrance_flag, pod.ussgl_transaction_code, pod.government_context, 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, pod.code_combination_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.kanban_card_id, pod.end_item_unit_number, pod.award_id, pod.mrc_rate_date, pod.mrc_rate, pod.mrc_encumbered_amount, pod.mrc_unencumbered_amount, pod.recoverable_tax, pod.nonrecoverable_tax, pod.recovery_rate, pod.tax_recovery_override_flag, pod.oke_contract_line_id, pod.oke_contract_deliverable_id, pod.amount_ordered, pod.amount_delivered, pod.amount_cancelled, pod.distribution_type, pod.amount_to_encumber, pod.invoice_adjustment_flag, pod.dest_charge_account_id, pod.dest_variance_account_id, pod.quantity_financed, pod.amount_financed, pod.quantity_recouped, pod.amount_recouped, pod.retainage_withheld_amount, pod.retainage_released_amount, pod.tax_attribute_update_code, pod.group_line_id, NULL, pod.uda_template_id, pod.partial_funded_flag, pod.funded_value, pod.quantity_funded, pod.amount_funded, pod.clm_misc_loa, pod.clm_defence_funding, pod.clm_fms_case_number, pod.clm_agency_acct_identifier, pod.change_in_funded_value, pod.quantity_ordered, pod.acrn, NULL, NULL, pod.clm_payment_sequence_num, NULL, NULL, NVL(pod.amount_changed_flag, 'N') FROM po_distributions_all pod UNION ALL SELECT To_number(NULL), NULL, NULL, dft.draft_id, NULL, NULL, pod.destination_context, pod.distribution_num, pod.source_distribution_id, pod.request_id, pod.program_application_id, pod.program_id, pod.program_update_date, pod.project_id, pod.task_id, pod.expenditure_type, pod.project_accounting_context, pod.expenditure_organization_id, pod.gl_closed_date, pod.accrue_on_receipt_flag, pod.expenditure_item_date, pod.org_id, 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.budget_account_id, pod.accrual_account_id, pod.variance_account_id, pod.prevent_encumbrance_flag, pod.ussgl_transaction_code, pod.government_context, 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, pod.code_combination_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.kanban_card_id, pod.end_item_unit_number, pod.award_id, pod.mrc_rate_date, pod.mrc_rate, pod.mrc_encumbered_amount, pod.mrc_unencumbered_amount, pod.recoverable_tax, pod.nonrecoverable_tax, pod.recovery_rate, pod.tax_recovery_override_flag, pod.oke_contract_line_id, pod.oke_contract_deliverable_id, pod.amount_ordered, pod.amount_delivered, pod.amount_cancelled, pod.distribution_type, pod.amount_to_encumber, pod.invoice_adjustment_flag, pod.dest_charge_account_id, pod.dest_variance_account_id, pod.quantity_financed, pod.amount_financed, pod.quantity_recouped, pod.amount_recouped, pod.retainage_withheld_amount, pod.retainage_released_amount, pod.tax_attribute_update_code, pod.group_line_id, NULL, pod.uda_template_id, pod.partial_funded_flag, pod.funded_value, pod.quantity_funded, pod.amount_funded, pod.clm_misc_loa, pod.clm_defence_funding, pod.clm_fms_case_number, pod.clm_agency_acct_identifier, pod.change_in_funded_value, pod.quantity_ordered, pod.acrn, NULL, NULL, pod.clm_payment_sequence_num, NULL, NULL, NVL(pod.amount_changed_flag, 'N') FROM po_distributions_all pod, po_drafts dft WHERE pod.po_header_id = dft.document_id AND NOT EXISTS (SELECT 'Draft Exists For This Distribution' FROM po_distributions_draft_all podd WHERE pod.po_distribution_id = podd.po_distribution_id AND podd.draft_id = dft.draft_id AND Nvl(podd.delete_flag,'N') = 'N')

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PODD.CHANGE_ACCEPTED_FLAG
, PODD.DELETE_FLAG
, PODD.DESTINATION_CONTEXT
, PODD.DISTRIBUTION_NUM
, PODD.SOURCE_DISTRIBUTION_ID
, PODD.REQUEST_ID
, PODD.PROGRAM_APPLICATION_ID
, PODD.PROGRAM_ID
, PODD.PROGRAM_UPDATE_DATE
, PODD.PROJECT_ID
, PODD.TASK_ID
, PODD.EXPENDITURE_TYPE
, PODD.PROJECT_ACCOUNTING_CONTEXT
, PODD.EXPENDITURE_ORGANIZATION_ID
, PODD.GL_CLOSED_DATE
, PODD.ACCRUE_ON_RECEIPT_FLAG
, PODD.EXPENDITURE_ITEM_DATE
, PODD.ORG_ID
, PODD.GL_ENCUMBERED_PERIOD_NAME
, PODD.GL_CANCELLED_DATE
, PODD.DESTINATION_TYPE_CODE
, PODD.DESTINATION_ORGANIZATION_ID
, PODD.DESTINATION_SUBINVENTORY
, PODD.ATTRIBUTE_CATEGORY
, PODD.ATTRIBUTE1
, PODD.ATTRIBUTE2
, PODD.ATTRIBUTE3
, PODD.ATTRIBUTE4
, PODD.ATTRIBUTE5
, PODD.ATTRIBUTE6
, PODD.ATTRIBUTE7
, PODD.ATTRIBUTE8
, PODD.ATTRIBUTE9
, PODD.ATTRIBUTE10
, PODD.ATTRIBUTE11
, PODD.ATTRIBUTE12
, PODD.ATTRIBUTE13
, PODD.ATTRIBUTE14
, PODD.ATTRIBUTE15
, PODD.WIP_ENTITY_ID
, PODD.WIP_OPERATION_SEQ_NUM
, PODD.WIP_RESOURCE_SEQ_NUM
, PODD.WIP_REPETITIVE_SCHEDULE_ID
, PODD.WIP_LINE_ID
, PODD.BOM_RESOURCE_ID
, PODD.BUDGET_ACCOUNT_ID
, PODD.ACCRUAL_ACCOUNT_ID
, PODD.VARIANCE_ACCOUNT_ID
, PODD.PREVENT_ENCUMBRANCE_FLAG
, PODD.USSGL_TRANSACTION_CODE
, PODD.GOVERNMENT_CONTEXT
, PODD.PO_DISTRIBUTION_ID
, PODD.LAST_UPDATE_DATE
, PODD.LAST_UPDATED_BY
, PODD.PO_HEADER_ID
, PODD.PO_LINE_ID
, PODD.LINE_LOCATION_ID
, PODD.SET_OF_BOOKS_ID
, PODD.CODE_COMBINATION_ID
, PODD.QUANTITY_ORDERED
, PODD.LAST_UPDATE_LOGIN
, PODD.CREATION_DATE
, PODD.CREATED_BY
, PODD.PO_RELEASE_ID
, PODD.QUANTITY_DELIVERED
, PODD.QUANTITY_BILLED
, PODD.QUANTITY_CANCELLED
, PODD.REQ_HEADER_REFERENCE_NUM
, PODD.REQ_LINE_REFERENCE_NUM
, PODD.REQ_DISTRIBUTION_ID
, PODD.DELIVER_TO_LOCATION_ID
, PODD.DELIVER_TO_PERSON_ID
, PODD.RATE_DATE
, PODD.RATE
, PODD.AMOUNT_BILLED
, PODD.ACCRUED_FLAG
, PODD.ENCUMBERED_FLAG
, PODD.ENCUMBERED_AMOUNT
, PODD.UNENCUMBERED_QUANTITY
, PODD.UNENCUMBERED_AMOUNT
, PODD.FAILED_FUNDS_LOOKUP_CODE
, PODD.GL_ENCUMBERED_DATE
, PODD.KANBAN_CARD_ID
, PODD.END_ITEM_UNIT_NUMBER
, PODD.AWARD_ID
, PODD.MRC_RATE_DATE
, PODD.MRC_RATE
, PODD.MRC_ENCUMBERED_AMOUNT
, PODD.MRC_UNENCUMBERED_AMOUNT
, PODD.RECOVERABLE_TAX
, PODD.NONRECOVERABLE_TAX
, PODD.RECOVERY_RATE
, PODD.TAX_RECOVERY_OVERRIDE_FLAG
, PODD.OKE_CONTRACT_LINE_ID
, PODD.OKE_CONTRACT_DELIVERABLE_ID
, PODD.AMOUNT_ORDERED
, PODD.AMOUNT_DELIVERED
, PODD.AMOUNT_CANCELLED
, PODD.DISTRIBUTION_TYPE
, PODD.AMOUNT_TO_ENCUMBER
, PODD.INVOICE_ADJUSTMENT_FLAG
, PODD.DEST_CHARGE_ACCOUNT_ID
, PODD.DEST_VARIANCE_ACCOUNT_ID
, PODD.QUANTITY_FINANCED
, PODD.AMOUNT_FINANCED
, PODD.QUANTITY_RECOUPED
, PODD.AMOUNT_RECOUPED
, PODD.RETAINAGE_WITHHELD_AMOUNT
, PODD.RETAINAGE_RELEASED_AMOUNT
, PODD.TAX_ATTRIBUTE_UPDATE_CODE
, PODD.GROUP_LINE_ID
, PODD.CHANGE_STATUS
, PODD.UDA_TEMPLATE_ID
, PODD.PARTIAL_FUNDED_FLAG
, PODD.FUNDED_VALUE
, PODD.QUANTITY_FUNDED
, PODD.AMOUNT_FUNDED
, PODD.CLM_MISC_LOA
, PODD.CLM_DEFENCE_FUNDING
, PODD.CLM_FMS_CASE_NUMBER
, PODD.CLM_AGENCY_ACCT_IDENTIFIER
, PODD.CHANGE_IN_FUNDED_VALUE
, PODD.OLD_QUANTITY_ORDERED
, PODD.ACRN
, PODD.OLD_AMOUNT_ORDERED
, PODD.COMMENTS
, PODD.CLM_PAYMENT_SEQUENCE_NUM
, PODD.PAR_DRAFT_ID
, PODD.PAR_DISTRIBUTION_ID
, NVL(PODD.AMOUNT_CHANGED_FLAG
, 'N')
FROM PO_DISTRIBUTIONS_DRAFT_ALL PODD
, PO_DRAFTS DFT
WHERE PODD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PODD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, NULL
, NULL
, POD.DESTINATION_CONTEXT
, POD.DISTRIBUTION_NUM
, POD.SOURCE_DISTRIBUTION_ID
, POD.REQUEST_ID
, POD.PROGRAM_APPLICATION_ID
, POD.PROGRAM_ID
, POD.PROGRAM_UPDATE_DATE
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.PROJECT_ACCOUNTING_CONTEXT
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.GL_CLOSED_DATE
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.EXPENDITURE_ITEM_DATE
, POD.ORG_ID
, 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.BUDGET_ACCOUNT_ID
, POD.ACCRUAL_ACCOUNT_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.PREVENT_ENCUMBRANCE_FLAG
, POD.USSGL_TRANSACTION_CODE
, POD.GOVERNMENT_CONTEXT
, 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
, POD.CODE_COMBINATION_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.KANBAN_CARD_ID
, POD.END_ITEM_UNIT_NUMBER
, POD.AWARD_ID
, POD.MRC_RATE_DATE
, POD.MRC_RATE
, POD.MRC_ENCUMBERED_AMOUNT
, POD.MRC_UNENCUMBERED_AMOUNT
, POD.RECOVERABLE_TAX
, POD.NONRECOVERABLE_TAX
, POD.RECOVERY_RATE
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.DISTRIBUTION_TYPE
, POD.AMOUNT_TO_ENCUMBER
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.DEST_CHARGE_ACCOUNT_ID
, POD.DEST_VARIANCE_ACCOUNT_ID
, POD.QUANTITY_FINANCED
, POD.AMOUNT_FINANCED
, POD.QUANTITY_RECOUPED
, POD.AMOUNT_RECOUPED
, POD.RETAINAGE_WITHHELD_AMOUNT
, POD.RETAINAGE_RELEASED_AMOUNT
, POD.TAX_ATTRIBUTE_UPDATE_CODE
, POD.GROUP_LINE_ID
, NULL
, POD.UDA_TEMPLATE_ID
, POD.PARTIAL_FUNDED_FLAG
, POD.FUNDED_VALUE
, POD.QUANTITY_FUNDED
, POD.AMOUNT_FUNDED
, POD.CLM_MISC_LOA
, POD.CLM_DEFENCE_FUNDING
, POD.CLM_FMS_CASE_NUMBER
, POD.CLM_AGENCY_ACCT_IDENTIFIER
, POD.CHANGE_IN_FUNDED_VALUE
, POD.QUANTITY_ORDERED
, POD.ACRN
, NULL
, NULL
, POD.CLM_PAYMENT_SEQUENCE_NUM
, NULL
, NULL
, NVL(POD.AMOUNT_CHANGED_FLAG
, 'N')
FROM PO_DISTRIBUTIONS_ALL POD UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, NULL
, NULL
, POD.DESTINATION_CONTEXT
, POD.DISTRIBUTION_NUM
, POD.SOURCE_DISTRIBUTION_ID
, POD.REQUEST_ID
, POD.PROGRAM_APPLICATION_ID
, POD.PROGRAM_ID
, POD.PROGRAM_UPDATE_DATE
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.PROJECT_ACCOUNTING_CONTEXT
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.GL_CLOSED_DATE
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.EXPENDITURE_ITEM_DATE
, POD.ORG_ID
, 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.BUDGET_ACCOUNT_ID
, POD.ACCRUAL_ACCOUNT_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.PREVENT_ENCUMBRANCE_FLAG
, POD.USSGL_TRANSACTION_CODE
, POD.GOVERNMENT_CONTEXT
, 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
, POD.CODE_COMBINATION_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.KANBAN_CARD_ID
, POD.END_ITEM_UNIT_NUMBER
, POD.AWARD_ID
, POD.MRC_RATE_DATE
, POD.MRC_RATE
, POD.MRC_ENCUMBERED_AMOUNT
, POD.MRC_UNENCUMBERED_AMOUNT
, POD.RECOVERABLE_TAX
, POD.NONRECOVERABLE_TAX
, POD.RECOVERY_RATE
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.DISTRIBUTION_TYPE
, POD.AMOUNT_TO_ENCUMBER
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.DEST_CHARGE_ACCOUNT_ID
, POD.DEST_VARIANCE_ACCOUNT_ID
, POD.QUANTITY_FINANCED
, POD.AMOUNT_FINANCED
, POD.QUANTITY_RECOUPED
, POD.AMOUNT_RECOUPED
, POD.RETAINAGE_WITHHELD_AMOUNT
, POD.RETAINAGE_RELEASED_AMOUNT
, POD.TAX_ATTRIBUTE_UPDATE_CODE
, POD.GROUP_LINE_ID
, NULL
, POD.UDA_TEMPLATE_ID
, POD.PARTIAL_FUNDED_FLAG
, POD.FUNDED_VALUE
, POD.QUANTITY_FUNDED
, POD.AMOUNT_FUNDED
, POD.CLM_MISC_LOA
, POD.CLM_DEFENCE_FUNDING
, POD.CLM_FMS_CASE_NUMBER
, POD.CLM_AGENCY_ACCT_IDENTIFIER
, POD.CHANGE_IN_FUNDED_VALUE
, POD.QUANTITY_ORDERED
, POD.ACRN
, NULL
, NULL
, POD.CLM_PAYMENT_SEQUENCE_NUM
, NULL
, NULL
, NVL(POD.AMOUNT_CHANGED_FLAG
, 'N')
FROM PO_DISTRIBUTIONS_ALL POD
, PO_DRAFTS DFT
WHERE POD.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 'DRAFT EXISTS FOR THIS DISTRIBUTION'
FROM PO_DISTRIBUTIONS_DRAFT_ALL PODD
WHERE POD.PO_DISTRIBUTION_ID = PODD.PO_DISTRIBUTION_ID
AND PODD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PODD.DELETE_FLAG
, 'N') = 'N')