VIEW: APPS.PO_DISTRIBUTION_ARCHIVE_XML

Source

View Text - Preformatted

SELECT PD.PO_DISTRIBUTION_ID, TO_CHAR(PD.LAST_UPDATE_DATE,'DD-MON-YYYY HH24:MI:SS') LAST_UPDATE_DATE, PD.LAST_UPDATED_BY, PD.PO_HEADER_ID, PD.PO_LINE_ID, PD.LINE_LOCATION_ID, PD.SET_OF_BOOKS_ID, PD.CODE_COMBINATION_ID, PD.QUANTITY_ORDERED, PD.LAST_UPDATE_LOGIN, TO_CHAR(PD.CREATION_DATE,'DD-MON-YYYY HH24:MI:SS') CREATION_DATE, PD.CREATED_BY, PD.PO_RELEASE_ID, PD.QUANTITY_DELIVERED, PD.QUANTITY_BILLED, PD.QUANTITY_CANCELLED, PD.REQ_HEADER_REFERENCE_NUM, PD.REQ_LINE_REFERENCE_NUM, PD.REQ_DISTRIBUTION_ID, PD.DELIVER_TO_LOCATION_ID, PD.DELIVER_TO_PERSON_ID, TO_CHAR(PD.RATE_DATE,'DD-MON-YYYY HH24:MI:SS') RATE_DATE, TO_CHAR(PD.RATE,PGT.FORMAT_MASK) RATE, TO_CHAR(PD.AMOUNT_BILLED,PGT.FORMAT_MASK) AMOUNT_BILLED, PD.ACCRUED_FLAG, PD.ENCUMBERED_FLAG, TO_CHAR(PD.ENCUMBERED_AMOUNT,PGT.FORMAT_MASK) ENCUMBERED_AMOUNT, PD.UNENCUMBERED_QUANTITY, TO_CHAR(PD.UNENCUMBERED_AMOUNT,PGT.FORMAT_MASK) UNENCUMBERED_AMOUNT, PD.FAILED_FUNDS_LOOKUP_CODE, TO_CHAR(PD.GL_ENCUMBERED_DATE,'DD-MON-YYYY HH24:MI:SS') GL_ENCUMBERED_DATE, PD.GL_ENCUMBERED_PERIOD_NAME, TO_CHAR(PD.GL_CANCELLED_DATE,'DD-MON-YYYY HH24:MI:SS') GL_CANCELLED_DATE, PD.DESTINATION_TYPE_CODE, PD.DESTINATION_ORGANIZATION_ID, PD.DESTINATION_SUBINVENTORY, PD.ATTRIBUTE_CATEGORY, PD.ATTRIBUTE1, PD.ATTRIBUTE2, PD.ATTRIBUTE3, PD.ATTRIBUTE4, PD.ATTRIBUTE5, PD.ATTRIBUTE6, PD.ATTRIBUTE7, PD.ATTRIBUTE8, PD.ATTRIBUTE9, PD.ATTRIBUTE10, PD.ATTRIBUTE11, PD.ATTRIBUTE12, PD.ATTRIBUTE13, PD.ATTRIBUTE14, PD.ATTRIBUTE15, PD.WIP_ENTITY_ID, PD.WIP_OPERATION_SEQ_NUM, PD.WIP_RESOURCE_SEQ_NUM, PD.WIP_REPETITIVE_SCHEDULE_ID, PD.WIP_LINE_ID, PD.BOM_RESOURCE_ID, PD.BUDGET_ACCOUNT_ID, PD.ACCRUAL_ACCOUNT_ID, PD.VARIANCE_ACCOUNT_ID, PD.DESTINATION_CONTEXT, PD.DISTRIBUTION_NUM, PD.SOURCE_DISTRIBUTION_ID, PD.REVISION_NUM, PD.LATEST_EXTERNAL_FLAG, PD.REQUEST_ID, PD.PROGRAM_APPLICATION_ID, PD.PROGRAM_ID, TO_CHAR(PD.PROGRAM_UPDATE_DATE,'DD-MON-YYYY HH24:MI:SS') PROGRAM_UPDATE_DATE, PD.GOVERNMENT_CONTEXT, PD.PREVENT_ENCUMBRANCE_FLAG, PD.USSGL_TRANSACTION_CODE, PD.PROJECT_ID, PD.TASK_ID, PD.EXPENDITURE_TYPE, PD.PROJECT_ACCOUNTING_CONTEXT, PD.EXPENDITURE_ORGANIZATION_ID, PD.ACCRUE_ON_RECEIPT_FLAG, TO_CHAR(PD.GL_CLOSED_DATE,'DD-MON-YYYY HH24:MI:SS') GL_CLOSED_DATE, TO_CHAR(PD.EXPENDITURE_ITEM_DATE,'DD-MON-YYYY HH24:MI:SS') EXPENDITURE_ITEM_DATE, PD.ORG_ID, PD.END_ITEM_UNIT_NUMBER, PD.KANBAN_CARD_ID, PD.AWARD_ID, PD.MRC_RATE_DATE, PD.MRC_RATE, PD.MRC_ENCUMBERED_AMOUNT, PD.MRC_UNENCUMBERED_AMOUNT, TO_CHAR(PD.RECOVERABLE_TAX,PGT.FORMAT_MASK) RECOVERABLE_TAX, TO_CHAR(PD.NONRECOVERABLE_TAX,PGT.FORMAT_MASK) NONRECOVERABLE_TAX, TO_CHAR(PD.RECOVERY_RATE,PGT.FORMAT_MASK) RECOVERY_RATE, PD.TAX_RECOVERY_OVERRIDE_FLAG, TO_CHAR(PD.AMOUNT_ORDERED,PGT.FORMAT_MASK) AMOUNT_ORDERED, TO_CHAR(PD.AMOUNT_DELIVERED,PGT.FORMAT_MASK) AMOUNT_DELIVERED, TO_CHAR(PD.AMOUNT_CANCELLED,PGT.FORMAT_MASK) AMOUNT_CANCELLED, PD.INVOICE_ADJUSTMENT_FLAG, PD.OKE_CONTRACT_LINE_ID, PD.OKE_CONTRACT_DELIVERABLE_ID, PD.DISTRIBUTION_TYPE, TO_CHAR(PD.AMOUNT_TO_ENCUMBER,PGT.FORMAT_MASK) AMOUNT_TO_ENCUMBER, PD.DEST_CHARGE_ACCOUNT_ID, PD.DEST_VARIANCE_ACCOUNT_ID, CONCATENATED_SEGMENTS CHARGE_ACCOUNT, PAP.FULL_NAME, PO_COMMUNICATION_PVT.GETPHONE(PD.DELIVER_TO_PERSON_ID) WORK_TELEPHONE, EMAIL_ADDRESS, PAP.FIRST_NAME REQUESTER_DELIVER_FIRST_NAME, PAP.LAST_NAME REQUESTER_DELIVER_LAST_NAME, PAP.TITLE REQUESTER_DELIVER_TITLE, PD.QUANTITY_FINANCED, TO_CHAR(PD.AMOUNT_FINANCED, PGT.FORMAT_MASK) AMOUNT_FINANCED, PD.QUANTITY_RECOUPED, TO_CHAR(PD.AMOUNT_RECOUPED, PGT.FORMAT_MASK) AMOUNT_RECOUPED, TO_CHAR(PD.RETAINAGE_WITHHELD_AMOUNT, PGT.FORMAT_MASK) RETAINAGE_WITHHELD_AMOUNT, TO_CHAR(PD.RETAINAGE_RELEASED_AMOUNT, PGT.FORMAT_MASK) RETAINAGE_RELEASED_AMOUNT FROM PER_ALL_PEOPLE_F PAP, PO_DISTRIBUTIONS_ARCHIVE_ALL PD, GL_CODE_COMBINATIONS_KFV GCD, PO_COMMUNICATION_GT PGT WHERE GCD.CODE_COMBINATION_ID(+) = PD.CODE_COMBINATION_ID AND PAP.PERSON_ID(+) = PD.DELIVER_TO_PERSON_ID AND SYSDATE BETWEEN PAP.EFFECTIVE_START_DATE(+) AND PAP.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT PD.PO_DISTRIBUTION_ID
, TO_CHAR(PD.LAST_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') LAST_UPDATE_DATE
, PD.LAST_UPDATED_BY
, PD.PO_HEADER_ID
, PD.PO_LINE_ID
, PD.LINE_LOCATION_ID
, PD.SET_OF_BOOKS_ID
, PD.CODE_COMBINATION_ID
, PD.QUANTITY_ORDERED
, PD.LAST_UPDATE_LOGIN
, TO_CHAR(PD.CREATION_DATE
, 'DD-MON-YYYY HH24:MI:SS') CREATION_DATE
, PD.CREATED_BY
, PD.PO_RELEASE_ID
, PD.QUANTITY_DELIVERED
, PD.QUANTITY_BILLED
, PD.QUANTITY_CANCELLED
, PD.REQ_HEADER_REFERENCE_NUM
, PD.REQ_LINE_REFERENCE_NUM
, PD.REQ_DISTRIBUTION_ID
, PD.DELIVER_TO_LOCATION_ID
, PD.DELIVER_TO_PERSON_ID
, TO_CHAR(PD.RATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') RATE_DATE
, TO_CHAR(PD.RATE
, PGT.FORMAT_MASK) RATE
, TO_CHAR(PD.AMOUNT_BILLED
, PGT.FORMAT_MASK) AMOUNT_BILLED
, PD.ACCRUED_FLAG
, PD.ENCUMBERED_FLAG
, TO_CHAR(PD.ENCUMBERED_AMOUNT
, PGT.FORMAT_MASK) ENCUMBERED_AMOUNT
, PD.UNENCUMBERED_QUANTITY
, TO_CHAR(PD.UNENCUMBERED_AMOUNT
, PGT.FORMAT_MASK) UNENCUMBERED_AMOUNT
, PD.FAILED_FUNDS_LOOKUP_CODE
, TO_CHAR(PD.GL_ENCUMBERED_DATE
, 'DD-MON-YYYY HH24:MI:SS') GL_ENCUMBERED_DATE
, PD.GL_ENCUMBERED_PERIOD_NAME
, TO_CHAR(PD.GL_CANCELLED_DATE
, 'DD-MON-YYYY HH24:MI:SS') GL_CANCELLED_DATE
, PD.DESTINATION_TYPE_CODE
, PD.DESTINATION_ORGANIZATION_ID
, PD.DESTINATION_SUBINVENTORY
, PD.ATTRIBUTE_CATEGORY
, PD.ATTRIBUTE1
, PD.ATTRIBUTE2
, PD.ATTRIBUTE3
, PD.ATTRIBUTE4
, PD.ATTRIBUTE5
, PD.ATTRIBUTE6
, PD.ATTRIBUTE7
, PD.ATTRIBUTE8
, PD.ATTRIBUTE9
, PD.ATTRIBUTE10
, PD.ATTRIBUTE11
, PD.ATTRIBUTE12
, PD.ATTRIBUTE13
, PD.ATTRIBUTE14
, PD.ATTRIBUTE15
, PD.WIP_ENTITY_ID
, PD.WIP_OPERATION_SEQ_NUM
, PD.WIP_RESOURCE_SEQ_NUM
, PD.WIP_REPETITIVE_SCHEDULE_ID
, PD.WIP_LINE_ID
, PD.BOM_RESOURCE_ID
, PD.BUDGET_ACCOUNT_ID
, PD.ACCRUAL_ACCOUNT_ID
, PD.VARIANCE_ACCOUNT_ID
, PD.DESTINATION_CONTEXT
, PD.DISTRIBUTION_NUM
, PD.SOURCE_DISTRIBUTION_ID
, PD.REVISION_NUM
, PD.LATEST_EXTERNAL_FLAG
, PD.REQUEST_ID
, PD.PROGRAM_APPLICATION_ID
, PD.PROGRAM_ID
, TO_CHAR(PD.PROGRAM_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') PROGRAM_UPDATE_DATE
, PD.GOVERNMENT_CONTEXT
, PD.PREVENT_ENCUMBRANCE_FLAG
, PD.USSGL_TRANSACTION_CODE
, PD.PROJECT_ID
, PD.TASK_ID
, PD.EXPENDITURE_TYPE
, PD.PROJECT_ACCOUNTING_CONTEXT
, PD.EXPENDITURE_ORGANIZATION_ID
, PD.ACCRUE_ON_RECEIPT_FLAG
, TO_CHAR(PD.GL_CLOSED_DATE
, 'DD-MON-YYYY HH24:MI:SS') GL_CLOSED_DATE
, TO_CHAR(PD.EXPENDITURE_ITEM_DATE
, 'DD-MON-YYYY HH24:MI:SS') EXPENDITURE_ITEM_DATE
, PD.ORG_ID
, PD.END_ITEM_UNIT_NUMBER
, PD.KANBAN_CARD_ID
, PD.AWARD_ID
, PD.MRC_RATE_DATE
, PD.MRC_RATE
, PD.MRC_ENCUMBERED_AMOUNT
, PD.MRC_UNENCUMBERED_AMOUNT
, TO_CHAR(PD.RECOVERABLE_TAX
, PGT.FORMAT_MASK) RECOVERABLE_TAX
, TO_CHAR(PD.NONRECOVERABLE_TAX
, PGT.FORMAT_MASK) NONRECOVERABLE_TAX
, TO_CHAR(PD.RECOVERY_RATE
, PGT.FORMAT_MASK) RECOVERY_RATE
, PD.TAX_RECOVERY_OVERRIDE_FLAG
, TO_CHAR(PD.AMOUNT_ORDERED
, PGT.FORMAT_MASK) AMOUNT_ORDERED
, TO_CHAR(PD.AMOUNT_DELIVERED
, PGT.FORMAT_MASK) AMOUNT_DELIVERED
, TO_CHAR(PD.AMOUNT_CANCELLED
, PGT.FORMAT_MASK) AMOUNT_CANCELLED
, PD.INVOICE_ADJUSTMENT_FLAG
, PD.OKE_CONTRACT_LINE_ID
, PD.OKE_CONTRACT_DELIVERABLE_ID
, PD.DISTRIBUTION_TYPE
, TO_CHAR(PD.AMOUNT_TO_ENCUMBER
, PGT.FORMAT_MASK) AMOUNT_TO_ENCUMBER
, PD.DEST_CHARGE_ACCOUNT_ID
, PD.DEST_VARIANCE_ACCOUNT_ID
, CONCATENATED_SEGMENTS CHARGE_ACCOUNT
, PAP.FULL_NAME
, PO_COMMUNICATION_PVT.GETPHONE(PD.DELIVER_TO_PERSON_ID) WORK_TELEPHONE
, EMAIL_ADDRESS
, PAP.FIRST_NAME REQUESTER_DELIVER_FIRST_NAME
, PAP.LAST_NAME REQUESTER_DELIVER_LAST_NAME
, PAP.TITLE REQUESTER_DELIVER_TITLE
, PD.QUANTITY_FINANCED
, TO_CHAR(PD.AMOUNT_FINANCED
, PGT.FORMAT_MASK) AMOUNT_FINANCED
, PD.QUANTITY_RECOUPED
, TO_CHAR(PD.AMOUNT_RECOUPED
, PGT.FORMAT_MASK) AMOUNT_RECOUPED
, TO_CHAR(PD.RETAINAGE_WITHHELD_AMOUNT
, PGT.FORMAT_MASK) RETAINAGE_WITHHELD_AMOUNT
, TO_CHAR(PD.RETAINAGE_RELEASED_AMOUNT
, PGT.FORMAT_MASK) RETAINAGE_RELEASED_AMOUNT
FROM PER_ALL_PEOPLE_F PAP
, PO_DISTRIBUTIONS_ARCHIVE_ALL PD
, GL_CODE_COMBINATIONS_KFV GCD
, PO_COMMUNICATION_GT PGT
WHERE GCD.CODE_COMBINATION_ID(+) = PD.CODE_COMBINATION_ID
AND PAP.PERSON_ID(+) = PD.DELIVER_TO_PERSON_ID
AND SYSDATE BETWEEN PAP.EFFECTIVE_START_DATE(+)
AND PAP.EFFECTIVE_END_DATE(+)