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 FROM po_distributions_draft_all PODD, po_drafts DFT WHERE PODD.draft_id = DFT.draft_id AND NVL(PODD.delete_flag, 'N') = 'N' AND DFT.owner_role = PO_GLOBAL.role AND DFT.status <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL) , NULL , NULL , TO_NUMBER(NULL) , 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 FROM PO_DISTRIBUTIONS_ALL POD WHERE NOT EXISTS ( SELECT 1 FROM po_distributions_draft_all PODD1, po_drafts DFT1 WHERE POD.po_distribution_id = PODD1.po_distribution_id AND PODD1.draft_id = DFT1.draft_id AND DFT1.owner_role = PO_GLOBAL.role AND DFT1.status <> 'COMPLETED')

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
FROM PO_DISTRIBUTIONS_DRAFT_ALL PODD
, PO_DRAFTS DFT
WHERE PODD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PODD.DELETE_FLAG
, 'N') = 'N'
AND DFT.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT.STATUS <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, 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
FROM PO_DISTRIBUTIONS_ALL POD
WHERE NOT EXISTS ( SELECT 1
FROM PO_DISTRIBUTIONS_DRAFT_ALL PODD1
, PO_DRAFTS DFT1
WHERE POD.PO_DISTRIBUTION_ID = PODD1.PO_DISTRIBUTION_ID
AND PODD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED')