VIEW: APPS.IGI_CEC_DIST_SUMMARY

Source

View Text - Preformatted

SELECT PARENT_DIST_ID , PO_DISTRIBUTION_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , PO_HEADER_ID , PO_LINE_ID , LINE_LOCATION_ID , SET_OF_BOOKS_ID , CODE_COMBINATION_ID , QUANTITY_ORDERED , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , 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 , PREVENT_ENCUMBRANCE_FLAG , USSGL_TRANSACTION_CODE , GOVERNMENT_CONTEXT , DESTINATION_CONTEXT , DISTRIBUTION_NUM , SOURCE_DISTRIBUTION_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , TASK_ID , EXPENDITURE_TYPE , PROJECT_ACCOUNTING_CONTEXT , EXPENDITURE_ORGANIZATION_ID , GL_CLOSED_DATE , ACCRUE_ON_RECEIPT_FLAG , EXPENDITURE_ITEM_DATE , KANBAN_CARD_ID , AWARD_ID , MRC_RATE_DATE , MRC_RATE , MRC_ENCUMBERED_AMOUNT , MRC_UNENCUMBERED_AMOUNT , END_ITEM_UNIT_NUMBER , RECOVERABLE_TAX , NONRECOVERABLE_TAX , RECOVERY_RATE , TAX_RECOVERY_OVERRIDE_FLAG, BASE_AMOUNT_BILLED , TAX_RECOVERY_RATE , MRC_BASE_AMOUNT_BILLED FROM IGI_CEC_DIST_SUMMARY_ALL WHERE NVL(org_id,NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1), ' ', NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT PARENT_DIST_ID
, PO_DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, QUANTITY_ORDERED
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, 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
, PREVENT_ENCUMBRANCE_FLAG
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, DESTINATION_CONTEXT
, DISTRIBUTION_NUM
, SOURCE_DISTRIBUTION_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID
, GL_CLOSED_DATE
, ACCRUE_ON_RECEIPT_FLAG
, EXPENDITURE_ITEM_DATE
, KANBAN_CARD_ID
, AWARD_ID
, MRC_RATE_DATE
, MRC_RATE
, MRC_ENCUMBERED_AMOUNT
, MRC_UNENCUMBERED_AMOUNT
, END_ITEM_UNIT_NUMBER
, RECOVERABLE_TAX
, NONRECOVERABLE_TAX
, RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG
, BASE_AMOUNT_BILLED
, TAX_RECOVERY_RATE
, MRC_BASE_AMOUNT_BILLED
FROM IGI_CEC_DIST_SUMMARY_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)