VIEW: APPS.PO_DISTRIBUTION_CHANGES_V

Source

View Text - Preformatted

SELECT "MOD_DOC_PK1_VAL", "MOD_DOC_PK2_VAL", "MOD_DOC_PK5_VAL", "ENTITY_NAME", "MOD_DOC_PK3_VAL", "MOD_DOC_PK4_VAL", "SET_OF_BOOKS_ID", "CODE_COMBINATION_ID", "QUANTITY_ORDERED", "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", "BUDGET_ACCOUNT_ID", "ACCRUAL_ACCOUNT_ID", "VARIANCE_ACCOUNT_ID", "DESTINATION_CONTEXT", "DISTRIBUTION_NUM", "SOURCE_DISTRIBUTION_ID", "REVISION_NUM", "LATEST_EXTERNAL_FLAG", "REQUEST_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "GOVERNMENT_CONTEXT", "PREVENT_ENCUMBRANCE_FLAG", "USSGL_TRANSACTION_CODE", "PROJECT_ID", "TASK_ID", "EXPENDITURE_TYPE", "PROJECT_ACCOUNTING_CONTEXT", "EXPENDITURE_ORGANIZATION_ID", "ACCRUE_ON_RECEIPT_FLAG", "GL_CLOSED_DATE", "EXPENDITURE_ITEM_DATE", "ORG_ID", "END_ITEM_UNIT_NUMBER", "KANBAN_CARD_ID", "AWARD_ID", "MRC_RATE_DATE", "MRC_RATE", "MRC_ENCUMBERED_AMOUNT", "MRC_UNENCUMBERED_AMOUNT", "RECOVERABLE_TAX", "NONRECOVERABLE_TAX", "RECOVERY_RATE", "TAX_RECOVERY_OVERRIDE_FLAG", "OKE_CONTRACT_LINE_ID", "OKE_CONTRACT_DELIVERABLE_ID", "AMOUNT_ORDERED", "AMOUNT_DELIVERED", "AMOUNT_CANCELLED", "DISTRIBUTION_TYPE", "AMOUNT_TO_ENCUMBER", "INVOICE_ADJUSTMENT_FLAG", "DEST_CHARGE_ACCOUNT_ID", "DEST_VARIANCE_ACCOUNT_ID", "QUANTITY_FINANCED", "AMOUNT_FINANCED", "QUANTITY_RECOUPED", "AMOUNT_RECOUPED", "RETAINAGE_WITHHELD_AMOUNT", "RETAINAGE_RELEASED_AMOUNT", "GROUP_LINE_ID", "AMOUNT_FUNDED", "FUNDED_VALUE", "PARTIAL_FUNDED_FLAG", "QUANTITY_FUNDED", "CHANGE_IN_FUNDED_VALUE", "CLM_AGENCY_ACCT_IDENTIFIER", "CLM_DEFENCE_FUNDING", "CLM_FMS_CASE_NUMBER", "CLM_MISC_LOA", "EVENT_ID", "INTERFACE_DISTRIBUTION_REF", "INVOICED_VAL_IN_NTFN", "LCM_FLAG", "TAX_ATTRIBUTE_UPDATE_CODE", "UDA_TEMPLATE_ID", "WF_ITEM_KEY", "ACRN", "CLM_PAYMENT_SEQUENCE_NUM" FROM (SELECT MOD_DOC_PK1_VAL,MOD_DOC_PK2_VAL,MOD_DOC_PK5_VAL, ENTITY_NAME,MOD_DOC_PK3_VAL, MOD_DOC_PK4_VAL, column_name,mod_value from po_entity_differences where MOD_DOC_SOURCE_NAME = 'PO_DISTRIBUTIONS_DRAFT_DIFF_V' AND entity_name = 'DISTRIBUTION') pivot(Max(mod_value) FOR column_name IN ( 'PO_LINE_ID' PO_LINE_ID, 'LINE_LOCATION_ID' LINE_LOCATION_ID, 'SET_OF_BOOKS_ID' SET_OF_BOOKS_ID, 'CODE_COMBINATION_ID' CODE_COMBINATION_ID, 'QUANTITY_ORDERED' QUANTITY_ORDERED, 'PO_RELEASE_ID' PO_RELEASE_ID, 'QUANTITY_DELIVERED' QUANTITY_DELIVERED, 'QUANTITY_BILLED' QUANTITY_BILLED, 'QUANTITY_CANCELLED' QUANTITY_CANCELLED, 'REQ_HEADER_REFERENCE_NUM' REQ_HEADER_REFERENCE_NUM, 'REQ_LINE_REFERENCE_NUM' REQ_LINE_REFERENCE_NUM, 'REQ_DISTRIBUTION_ID' REQ_DISTRIBUTION_ID, 'DELIVER_TO_LOCATION_ID' DELIVER_TO_LOCATION_ID, 'DELIVER_TO_PERSON_ID' DELIVER_TO_PERSON_ID, 'RATE_DATE' RATE_DATE, 'RATE' RATE, 'AMOUNT_BILLED' AMOUNT_BILLED, 'ACCRUED_FLAG' ACCRUED_FLAG, 'ENCUMBERED_FLAG' ENCUMBERED_FLAG, 'ENCUMBERED_AMOUNT' ENCUMBERED_AMOUNT, 'UNENCUMBERED_QUANTITY' UNENCUMBERED_QUANTITY, 'UNENCUMBERED_AMOUNT' UNENCUMBERED_AMOUNT, 'FAILED_FUNDS_LOOKUP_CODE' FAILED_FUNDS_LOOKUP_CODE, 'GL_ENCUMBERED_DATE' GL_ENCUMBERED_DATE, 'GL_ENCUMBERED_PERIOD_NAME' GL_ENCUMBERED_PERIOD_NAME, 'GL_CANCELLED_DATE' GL_CANCELLED_DATE, 'DESTINATION_TYPE_CODE' DESTINATION_TYPE_CODE, 'DESTINATION_ORGANIZATION_ID' DESTINATION_ORGANIZATION_ID, 'DESTINATION_SUBINVENTORY' DESTINATION_SUBINVENTORY, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY, 'ATTRIBUTE1' ATTRIBUTE1, 'ATTRIBUTE2' ATTRIBUTE2, 'ATTRIBUTE3' ATTRIBUTE3, 'ATTRIBUTE4' ATTRIBUTE4, 'ATTRIBUTE5' ATTRIBUTE5, 'ATTRIBUTE6' ATTRIBUTE6, 'ATTRIBUTE7' ATTRIBUTE7, 'ATTRIBUTE8' ATTRIBUTE8, 'ATTRIBUTE9' ATTRIBUTE9, 'ATTRIBUTE10' ATTRIBUTE10, 'ATTRIBUTE11' ATTRIBUTE11, 'ATTRIBUTE12' ATTRIBUTE12, 'ATTRIBUTE13' ATTRIBUTE13, 'ATTRIBUTE14' ATTRIBUTE14, 'ATTRIBUTE15' ATTRIBUTE15, 'WIP_ENTITY_ID' WIP_ENTITY_ID, 'WIP_OPERATION_SEQ_NUM' WIP_OPERATION_SEQ_NUM, 'WIP_RESOURCE_SEQ_NUM' WIP_RESOURCE_SEQ_NUM, 'WIP_REPETITIVE_SCHEDULE_ID' WIP_REPETITIVE_SCHEDULE_ID, 'WIP_LINE_ID' WIP_LINE_ID, 'BOM_RESOURCE_ID' BOM_RESOURCE_ID, 'BUDGET_ACCOUNT_ID' BUDGET_ACCOUNT_ID, 'ACCRUAL_ACCOUNT_ID' ACCRUAL_ACCOUNT_ID, 'VARIANCE_ACCOUNT_ID' VARIANCE_ACCOUNT_ID, 'DESTINATION_CONTEXT' DESTINATION_CONTEXT, 'DISTRIBUTION_NUM' DISTRIBUTION_NUM, 'SOURCE_DISTRIBUTION_ID' SOURCE_DISTRIBUTION_ID, 'REVISION_NUM' REVISION_NUM, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG, 'REQUEST_ID' REQUEST_ID, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID, 'PROGRAM_ID' PROGRAM_ID, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT, 'PREVENT_ENCUMBRANCE_FLAG' PREVENT_ENCUMBRANCE_FLAG, 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE, 'PROJECT_ID' PROJECT_ID, 'TASK_ID' TASK_ID, 'EXPENDITURE_TYPE' EXPENDITURE_TYPE, 'PROJECT_ACCOUNTING_CONTEXT' PROJECT_ACCOUNTING_CONTEXT, 'EXPENDITURE_ORGANIZATION_ID' EXPENDITURE_ORGANIZATION_ID, 'ACCRUE_ON_RECEIPT_FLAG' ACCRUE_ON_RECEIPT_FLAG, 'GL_CLOSED_DATE' GL_CLOSED_DATE, 'EXPENDITURE_ITEM_DATE' EXPENDITURE_ITEM_DATE, 'ORG_ID' ORG_ID, 'END_ITEM_UNIT_NUMBER' END_ITEM_UNIT_NUMBER, 'KANBAN_CARD_ID' KANBAN_CARD_ID, 'AWARD_ID' AWARD_ID, 'MRC_RATE_DATE' MRC_RATE_DATE, 'MRC_RATE' MRC_RATE, 'MRC_ENCUMBERED_AMOUNT' MRC_ENCUMBERED_AMOUNT, 'MRC_UNENCUMBERED_AMOUNT' MRC_UNENCUMBERED_AMOUNT, 'RECOVERABLE_TAX' RECOVERABLE_TAX, 'NONRECOVERABLE_TAX' NONRECOVERABLE_TAX, 'RECOVERY_RATE' RECOVERY_RATE, 'TAX_RECOVERY_OVERRIDE_FLAG' TAX_RECOVERY_OVERRIDE_FLAG, 'OKE_CONTRACT_LINE_ID' OKE_CONTRACT_LINE_ID, 'OKE_CONTRACT_DELIVERABLE_ID' OKE_CONTRACT_DELIVERABLE_ID, 'AMOUNT_ORDERED' AMOUNT_ORDERED, 'AMOUNT_DELIVERED' AMOUNT_DELIVERED, 'AMOUNT_CANCELLED' AMOUNT_CANCELLED, 'DISTRIBUTION_TYPE' DISTRIBUTION_TYPE, 'AMOUNT_TO_ENCUMBER' AMOUNT_TO_ENCUMBER, 'INVOICE_ADJUSTMENT_FLAG' INVOICE_ADJUSTMENT_FLAG, 'DEST_CHARGE_ACCOUNT_ID' DEST_CHARGE_ACCOUNT_ID, 'DEST_VARIANCE_ACCOUNT_ID' DEST_VARIANCE_ACCOUNT_ID, 'QUANTITY_FINANCED' QUANTITY_FINANCED, 'AMOUNT_FINANCED' AMOUNT_FINANCED, 'QUANTITY_RECOUPED' QUANTITY_RECOUPED, 'AMOUNT_RECOUPED' AMOUNT_RECOUPED, 'RETAINAGE_WITHHELD_AMOUNT' RETAINAGE_WITHHELD_AMOUNT, 'RETAINAGE_RELEASED_AMOUNT' RETAINAGE_RELEASED_AMOUNT, 'GROUP_LINE_ID' GROUP_LINE_ID, 'AMOUNT_FUNDED' AMOUNT_FUNDED, 'FUNDED_VALUE' FUNDED_VALUE, 'PARTIAL_FUNDED_FLAG' PARTIAL_FUNDED_FLAG, 'QUANTITY_FUNDED' QUANTITY_FUNDED, 'CHANGE_IN_FUNDED_VALUE' CHANGE_IN_FUNDED_VALUE, 'CLM_AGENCY_ACCT_IDENTIFIER' CLM_AGENCY_ACCT_IDENTIFIER, 'CLM_DEFENCE_FUNDING' CLM_DEFENCE_FUNDING, 'CLM_FMS_CASE_NUMBER' CLM_FMS_CASE_NUMBER, 'CLM_MISC_LOA' CLM_MISC_LOA, 'EVENT_ID' EVENT_ID, 'INTERFACE_DISTRIBUTION_REF' INTERFACE_DISTRIBUTION_REF, 'INVOICED_VAL_IN_NTFN' INVOICED_VAL_IN_NTFN, 'LCM_FLAG' LCM_FLAG, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID, 'WF_ITEM_KEY' WF_ITEM_KEY, 'ACRN' ACRN, 'CLM_PAYMENT_SEQUENCE_NUM' CLM_PAYMENT_SEQUENCE_NUM))

View Text - HTML Formatted

SELECT "MOD_DOC_PK1_VAL"
, "MOD_DOC_PK2_VAL"
, "MOD_DOC_PK5_VAL"
, "ENTITY_NAME"
, "MOD_DOC_PK3_VAL"
, "MOD_DOC_PK4_VAL"
, "SET_OF_BOOKS_ID"
, "CODE_COMBINATION_ID"
, "QUANTITY_ORDERED"
, "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"
, "BUDGET_ACCOUNT_ID"
, "ACCRUAL_ACCOUNT_ID"
, "VARIANCE_ACCOUNT_ID"
, "DESTINATION_CONTEXT"
, "DISTRIBUTION_NUM"
, "SOURCE_DISTRIBUTION_ID"
, "REVISION_NUM"
, "LATEST_EXTERNAL_FLAG"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "GOVERNMENT_CONTEXT"
, "PREVENT_ENCUMBRANCE_FLAG"
, "USSGL_TRANSACTION_CODE"
, "PROJECT_ID"
, "TASK_ID"
, "EXPENDITURE_TYPE"
, "PROJECT_ACCOUNTING_CONTEXT"
, "EXPENDITURE_ORGANIZATION_ID"
, "ACCRUE_ON_RECEIPT_FLAG"
, "GL_CLOSED_DATE"
, "EXPENDITURE_ITEM_DATE"
, "ORG_ID"
, "END_ITEM_UNIT_NUMBER"
, "KANBAN_CARD_ID"
, "AWARD_ID"
, "MRC_RATE_DATE"
, "MRC_RATE"
, "MRC_ENCUMBERED_AMOUNT"
, "MRC_UNENCUMBERED_AMOUNT"
, "RECOVERABLE_TAX"
, "NONRECOVERABLE_TAX"
, "RECOVERY_RATE"
, "TAX_RECOVERY_OVERRIDE_FLAG"
, "OKE_CONTRACT_LINE_ID"
, "OKE_CONTRACT_DELIVERABLE_ID"
, "AMOUNT_ORDERED"
, "AMOUNT_DELIVERED"
, "AMOUNT_CANCELLED"
, "DISTRIBUTION_TYPE"
, "AMOUNT_TO_ENCUMBER"
, "INVOICE_ADJUSTMENT_FLAG"
, "DEST_CHARGE_ACCOUNT_ID"
, "DEST_VARIANCE_ACCOUNT_ID"
, "QUANTITY_FINANCED"
, "AMOUNT_FINANCED"
, "QUANTITY_RECOUPED"
, "AMOUNT_RECOUPED"
, "RETAINAGE_WITHHELD_AMOUNT"
, "RETAINAGE_RELEASED_AMOUNT"
, "GROUP_LINE_ID"
, "AMOUNT_FUNDED"
, "FUNDED_VALUE"
, "PARTIAL_FUNDED_FLAG"
, "QUANTITY_FUNDED"
, "CHANGE_IN_FUNDED_VALUE"
, "CLM_AGENCY_ACCT_IDENTIFIER"
, "CLM_DEFENCE_FUNDING"
, "CLM_FMS_CASE_NUMBER"
, "CLM_MISC_LOA"
, "EVENT_ID"
, "INTERFACE_DISTRIBUTION_REF"
, "INVOICED_VAL_IN_NTFN"
, "LCM_FLAG"
, "TAX_ATTRIBUTE_UPDATE_CODE"
, "UDA_TEMPLATE_ID"
, "WF_ITEM_KEY"
, "ACRN"
, "CLM_PAYMENT_SEQUENCE_NUM"
FROM (SELECT MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL
, MOD_DOC_PK5_VAL
, ENTITY_NAME
, MOD_DOC_PK3_VAL
, MOD_DOC_PK4_VAL
, COLUMN_NAME
, MOD_VALUE
FROM PO_ENTITY_DIFFERENCES
WHERE MOD_DOC_SOURCE_NAME = 'PO_DISTRIBUTIONS_DRAFT_DIFF_V'
AND ENTITY_NAME = 'DISTRIBUTION') PIVOT(MAX(MOD_VALUE) FOR COLUMN_NAME IN ( 'PO_LINE_ID' PO_LINE_ID
, 'LINE_LOCATION_ID' LINE_LOCATION_ID
, 'SET_OF_BOOKS_ID' SET_OF_BOOKS_ID
, 'CODE_COMBINATION_ID' CODE_COMBINATION_ID
, 'QUANTITY_ORDERED' QUANTITY_ORDERED
, 'PO_RELEASE_ID' PO_RELEASE_ID
, 'QUANTITY_DELIVERED' QUANTITY_DELIVERED
, 'QUANTITY_BILLED' QUANTITY_BILLED
, 'QUANTITY_CANCELLED' QUANTITY_CANCELLED
, 'REQ_HEADER_REFERENCE_NUM' REQ_HEADER_REFERENCE_NUM
, 'REQ_LINE_REFERENCE_NUM' REQ_LINE_REFERENCE_NUM
, 'REQ_DISTRIBUTION_ID' REQ_DISTRIBUTION_ID
, 'DELIVER_TO_LOCATION_ID' DELIVER_TO_LOCATION_ID
, 'DELIVER_TO_PERSON_ID' DELIVER_TO_PERSON_ID
, 'RATE_DATE' RATE_DATE
, 'RATE' RATE
, 'AMOUNT_BILLED' AMOUNT_BILLED
, 'ACCRUED_FLAG' ACCRUED_FLAG
, 'ENCUMBERED_FLAG' ENCUMBERED_FLAG
, 'ENCUMBERED_AMOUNT' ENCUMBERED_AMOUNT
, 'UNENCUMBERED_QUANTITY' UNENCUMBERED_QUANTITY
, 'UNENCUMBERED_AMOUNT' UNENCUMBERED_AMOUNT
, 'FAILED_FUNDS_LOOKUP_CODE' FAILED_FUNDS_LOOKUP_CODE
, 'GL_ENCUMBERED_DATE' GL_ENCUMBERED_DATE
, 'GL_ENCUMBERED_PERIOD_NAME' GL_ENCUMBERED_PERIOD_NAME
, 'GL_CANCELLED_DATE' GL_CANCELLED_DATE
, 'DESTINATION_TYPE_CODE' DESTINATION_TYPE_CODE
, 'DESTINATION_ORGANIZATION_ID' DESTINATION_ORGANIZATION_ID
, 'DESTINATION_SUBINVENTORY' DESTINATION_SUBINVENTORY
, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY
, 'ATTRIBUTE1' ATTRIBUTE1
, 'ATTRIBUTE2' ATTRIBUTE2
, 'ATTRIBUTE3' ATTRIBUTE3
, 'ATTRIBUTE4' ATTRIBUTE4
, 'ATTRIBUTE5' ATTRIBUTE5
, 'ATTRIBUTE6' ATTRIBUTE6
, 'ATTRIBUTE7' ATTRIBUTE7
, 'ATTRIBUTE8' ATTRIBUTE8
, 'ATTRIBUTE9' ATTRIBUTE9
, 'ATTRIBUTE10' ATTRIBUTE10
, 'ATTRIBUTE11' ATTRIBUTE11
, 'ATTRIBUTE12' ATTRIBUTE12
, 'ATTRIBUTE13' ATTRIBUTE13
, 'ATTRIBUTE14' ATTRIBUTE14
, 'ATTRIBUTE15' ATTRIBUTE15
, 'WIP_ENTITY_ID' WIP_ENTITY_ID
, 'WIP_OPERATION_SEQ_NUM' WIP_OPERATION_SEQ_NUM
, 'WIP_RESOURCE_SEQ_NUM' WIP_RESOURCE_SEQ_NUM
, 'WIP_REPETITIVE_SCHEDULE_ID' WIP_REPETITIVE_SCHEDULE_ID
, 'WIP_LINE_ID' WIP_LINE_ID
, 'BOM_RESOURCE_ID' BOM_RESOURCE_ID
, 'BUDGET_ACCOUNT_ID' BUDGET_ACCOUNT_ID
, 'ACCRUAL_ACCOUNT_ID' ACCRUAL_ACCOUNT_ID
, 'VARIANCE_ACCOUNT_ID' VARIANCE_ACCOUNT_ID
, 'DESTINATION_CONTEXT' DESTINATION_CONTEXT
, 'DISTRIBUTION_NUM' DISTRIBUTION_NUM
, 'SOURCE_DISTRIBUTION_ID' SOURCE_DISTRIBUTION_ID
, 'REVISION_NUM' REVISION_NUM
, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG
, 'REQUEST_ID' REQUEST_ID
, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID
, 'PROGRAM_ID' PROGRAM_ID
, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE
, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT
, 'PREVENT_ENCUMBRANCE_FLAG' PREVENT_ENCUMBRANCE_FLAG
, 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE
, 'PROJECT_ID' PROJECT_ID
, 'TASK_ID' TASK_ID
, 'EXPENDITURE_TYPE' EXPENDITURE_TYPE
, 'PROJECT_ACCOUNTING_CONTEXT' PROJECT_ACCOUNTING_CONTEXT
, 'EXPENDITURE_ORGANIZATION_ID' EXPENDITURE_ORGANIZATION_ID
, 'ACCRUE_ON_RECEIPT_FLAG' ACCRUE_ON_RECEIPT_FLAG
, 'GL_CLOSED_DATE' GL_CLOSED_DATE
, 'EXPENDITURE_ITEM_DATE' EXPENDITURE_ITEM_DATE
, 'ORG_ID' ORG_ID
, 'END_ITEM_UNIT_NUMBER' END_ITEM_UNIT_NUMBER
, 'KANBAN_CARD_ID' KANBAN_CARD_ID
, 'AWARD_ID' AWARD_ID
, 'MRC_RATE_DATE' MRC_RATE_DATE
, 'MRC_RATE' MRC_RATE
, 'MRC_ENCUMBERED_AMOUNT' MRC_ENCUMBERED_AMOUNT
, 'MRC_UNENCUMBERED_AMOUNT' MRC_UNENCUMBERED_AMOUNT
, 'RECOVERABLE_TAX' RECOVERABLE_TAX
, 'NONRECOVERABLE_TAX' NONRECOVERABLE_TAX
, 'RECOVERY_RATE' RECOVERY_RATE
, 'TAX_RECOVERY_OVERRIDE_FLAG' TAX_RECOVERY_OVERRIDE_FLAG
, 'OKE_CONTRACT_LINE_ID' OKE_CONTRACT_LINE_ID
, 'OKE_CONTRACT_DELIVERABLE_ID' OKE_CONTRACT_DELIVERABLE_ID
, 'AMOUNT_ORDERED' AMOUNT_ORDERED
, 'AMOUNT_DELIVERED' AMOUNT_DELIVERED
, 'AMOUNT_CANCELLED' AMOUNT_CANCELLED
, 'DISTRIBUTION_TYPE' DISTRIBUTION_TYPE
, 'AMOUNT_TO_ENCUMBER' AMOUNT_TO_ENCUMBER
, 'INVOICE_ADJUSTMENT_FLAG' INVOICE_ADJUSTMENT_FLAG
, 'DEST_CHARGE_ACCOUNT_ID' DEST_CHARGE_ACCOUNT_ID
, 'DEST_VARIANCE_ACCOUNT_ID' DEST_VARIANCE_ACCOUNT_ID
, 'QUANTITY_FINANCED' QUANTITY_FINANCED
, 'AMOUNT_FINANCED' AMOUNT_FINANCED
, 'QUANTITY_RECOUPED' QUANTITY_RECOUPED
, 'AMOUNT_RECOUPED' AMOUNT_RECOUPED
, 'RETAINAGE_WITHHELD_AMOUNT' RETAINAGE_WITHHELD_AMOUNT
, 'RETAINAGE_RELEASED_AMOUNT' RETAINAGE_RELEASED_AMOUNT
, 'GROUP_LINE_ID' GROUP_LINE_ID
, 'AMOUNT_FUNDED' AMOUNT_FUNDED
, 'FUNDED_VALUE' FUNDED_VALUE
, 'PARTIAL_FUNDED_FLAG' PARTIAL_FUNDED_FLAG
, 'QUANTITY_FUNDED' QUANTITY_FUNDED
, 'CHANGE_IN_FUNDED_VALUE' CHANGE_IN_FUNDED_VALUE
, 'CLM_AGENCY_ACCT_IDENTIFIER' CLM_AGENCY_ACCT_IDENTIFIER
, 'CLM_DEFENCE_FUNDING' CLM_DEFENCE_FUNDING
, 'CLM_FMS_CASE_NUMBER' CLM_FMS_CASE_NUMBER
, 'CLM_MISC_LOA' CLM_MISC_LOA
, 'EVENT_ID' EVENT_ID
, 'INTERFACE_DISTRIBUTION_REF' INTERFACE_DISTRIBUTION_REF
, 'INVOICED_VAL_IN_NTFN' INVOICED_VAL_IN_NTFN
, 'LCM_FLAG' LCM_FLAG
, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE
, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID
, 'WF_ITEM_KEY' WF_ITEM_KEY
, 'ACRN' ACRN
, 'CLM_PAYMENT_SEQUENCE_NUM' CLM_PAYMENT_SEQUENCE_NUM))