Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: IGI.IGI_CEC_DIST_SUMMARY_ALL#

Object Details
Object Name: IGI_CEC_DIST_SUMMARY_ALL#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_DIST_ID NUMBER

PO_DISTRIBUTION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
LINE_LOCATION_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER
Yes
CODE_COMBINATION_ID NUMBER
Yes
QUANTITY_ORDERED NUMBER
Yes
DISTRIBUTION_NUM NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

PO_RELEASE_ID NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

REQ_HEADER_REFERENCE_NUM VARCHAR2 (25)
REQ_LINE_REFERENCE_NUM VARCHAR2 (25)
REQ_DISTRIBUTION_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)
RATE_DATE DATE

RATE NUMBER

AMOUNT_BILLED NUMBER

ACCRUED_FLAG VARCHAR2 (1)
ENCUMBERED_FLAG VARCHAR2 (1)
ENCUMBERED_AMOUNT NUMBER

UNENCUMBERED_QUANTITY NUMBER

UNENCUMBERED_AMOUNT NUMBER

FAILED_FUNDS_LOOKUP_CODE VARCHAR2 (25)
GL_ENCUMBERED_DATE DATE

GL_ENCUMBERED_PERIOD_NAME VARCHAR2 (15)
GL_CANCELLED_DATE DATE

DESTINATION_TYPE_CODE VARCHAR2 (25)
DESTINATION_ORGANIZATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (10)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
WIP_ENTITY_ID NUMBER

WIP_OPERATION_SEQ_NUM NUMBER

WIP_RESOURCE_SEQ_NUM NUMBER

WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP_LINE_ID NUMBER

BOM_RESOURCE_ID NUMBER

BUDGET_ACCOUNT_ID NUMBER

ACCRUAL_ACCOUNT_ID NUMBER

VARIANCE_ACCOUNT_ID NUMBER

PREVENT_ENCUMBRANCE_FLAG VARCHAR2 (1)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
GOVERNMENT_CONTEXT VARCHAR2 (30)
DESTINATION_CONTEXT VARCHAR2 (30)
SOURCE_DISTRIBUTION_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROJECT_ID NUMBER

TASK_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
EXPENDITURE_ORGANIZATION_ID NUMBER

GL_CLOSED_DATE DATE

ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
EXPENDITURE_ITEM_DATE DATE

ORG_ID NUMBER

KANBAN_CARD_ID NUMBER

AWARD_ID NUMBER (15)
MRC_RATE_DATE VARCHAR2 (2000)
MRC_RATE VARCHAR2 (2000)
MRC_ENCUMBERED_AMOUNT VARCHAR2 (2000)
MRC_UNENCUMBERED_AMOUNT VARCHAR2 (2000)
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
RECOVERABLE_TAX NUMBER

NONRECOVERABLE_TAX NUMBER

RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
BASE_AMOUNT_BILLED NUMBER

TAX_RECOVERY_RATE NUMBER (15)
MRC_BASE_AMOUNT_BILLED VARCHAR2 (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


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
,      DISTRIBUTION_NUM
,      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
,      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
,      ORG_ID
,      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.IGI_CEC_DIST_SUMMARY_ALL#;

Dependencies

[top of page]

IGI.IGI_CEC_DIST_SUMMARY_ALL# references the following:

SchemaIGI
TableIGI_CEC_DIST_SUMMARY_ALL
IGI.IGI_CEC_DIST_SUMMARY_ALL# is referenced by following:

SchemaAPPS
SynonymIGI_CEC_DIST_SUMMARY_ALL