View: PO_DISTRIBUTION_ARCHIVE_XML

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_DISTRIBUTION_ARCHIVE_XML

View Text

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
, PO_COMMUNICATION_PVT.GETFORMATMASK) RATE
, TO_CHAR(PD.AMOUNT_BILLED
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_BILLED
, PD.ACCRUED_FLAG
, PD.ENCUMBERED_FLAG
, TO_CHAR(PD.ENCUMBERED_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) ENCUMBERED_AMOUNT
, PD.UNENCUMBERED_QUANTITY
, TO_CHAR(PD.UNENCUMBERED_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) 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
, TO_CHAR(PD.MRC_RATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') MRC_RATE_DATE
, TO_CHAR(PD.MRC_RATE
, PO_COMMUNICATION_PVT.GETFORMATMASK) MRC_RATE
, TO_CHAR(PD.MRC_ENCUMBERED_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) MRC_ENCUMBERED_AMOUNT
, TO_CHAR(PD.MRC_UNENCUMBERED_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) MRC_UNENCUMBERED_AMOUNT
, TO_CHAR(PD.RECOVERABLE_TAX
, PO_COMMUNICATION_PVT.GETFORMATMASK) RECOVERABLE_TAX
, TO_CHAR(PD.NONRECOVERABLE_TAX
, PO_COMMUNICATION_PVT.GETFORMATMASK) NONRECOVERABLE_TAX
, TO_CHAR(PD.RECOVERY_RATE
, PO_COMMUNICATION_PVT.GETFORMATMASK) RECOVERY_RATE
, PD.TAX_RECOVERY_OVERRIDE_FLAG
, TO_CHAR(PD.AMOUNT_ORDERED
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_ORDERED
, TO_CHAR(PD.AMOUNT_DELIVERED
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_DELIVERED
, TO_CHAR(PD.AMOUNT_CANCELLED
, PO_COMMUNICATION_PVT.GETFORMATMASK) 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
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_TO_ENCUMBER
, PD.DEST_CHARGE_ACCOUNT_ID
, PD.DEST_VARIANCE_ACCOUNT_ID
, CONCATENATED_SEGMENTS CHARGE_ACCOUNT
, PAP.FULL_NAME
, WORK_TELEPHONE
, EMAIL_ADDRESS
, PAP.FIRST_NAME REQUESTER_DELIVER_FIRST_NAME
, PAP.LAST_NAME REQUESTER_DELIVER_LAST_NAME
, PAP.TITLE REQUESTER_DELIVER_TITLE
FROM PER_ALL_PEOPLE_F PAP
, PO_DISTRIBUTIONS_ARCHIVE_ALL PD
, GL_CODE_COMBINATIONS_KFV GCD
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(+)

Columns