VIEW: IGI.IGI_CEC_DIST_SUMMARY_ALL#

Source

View Text - Preformatted

select PARENT_DIST_ID PARENT_DIST_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PO_HEADER_ID PO_HEADER_ID, 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, DISTRIBUTION_NUM DISTRIBUTION_NUM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, DESTINATION_CONTEXT DESTINATION_CONTEXT, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, GL_CLOSED_DATE GL_CLOSED_DATE, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, ORG_ID ORG_ID, 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, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, RECOVERABLE_TAX RECOVERABLE_TAX, NONRECOVERABLE_TAX NONRECOVERABLE_TAX, RECOVERY_RATE RECOVERY_RATE, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, BASE_AMOUNT_BILLED BASE_AMOUNT_BILLED, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, MRC_BASE_AMOUNT_BILLED MRC_BASE_AMOUNT_BILLED from "IGI"."IGI_CEC_DIST_SUMMARY_ALL"

View Text - HTML Formatted

SELECT PARENT_DIST_ID PARENT_DIST_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PO_HEADER_ID PO_HEADER_ID
, 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
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, GL_CLOSED_DATE GL_CLOSED_DATE
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, ORG_ID ORG_ID
, 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
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, RECOVERABLE_TAX RECOVERABLE_TAX
, NONRECOVERABLE_TAX NONRECOVERABLE_TAX
, RECOVERY_RATE RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, BASE_AMOUNT_BILLED BASE_AMOUNT_BILLED
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, MRC_BASE_AMOUNT_BILLED MRC_BASE_AMOUNT_BILLED
FROM "IGI"."IGI_CEC_DIST_SUMMARY_ALL"