[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BC_PACKETS_HISTS# |
|---|---|
| Object Type: | VIEW |
| Owner: | GL |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PACKET_ID | NUMBER | (15) | Yes | |
| LEDGER_ID | NUMBER | (15) | Yes | |
| JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | |
| JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
| ACTUAL_FLAG | VARCHAR2 | (1) | Yes | |
| PERIOD_NAME | VARCHAR2 | (15) | Yes | |
| PERIOD_YEAR | NUMBER | (15) | Yes | |
| PERIOD_NUM | NUMBER | (15) | Yes | |
| QUARTER_NUM | NUMBER | (15) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| STATUS_CODE | VARCHAR2 | (1) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| BUDGET_VERSION_ID | NUMBER | (15) | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
| TEMPLATE_ID | NUMBER | (15) | ||
| ENTERED_DR | NUMBER | |||
| ENTERED_CR | NUMBER | |||
| ACCOUNTED_DR | NUMBER | |||
| ACCOUNTED_CR | NUMBER | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| ORIGINATING_ROWID | ROWID | (10) | ||
| ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
| AUTOMATIC_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | ||
| FUNDING_BUDGET_VERSION_ID | NUMBER | (15) | ||
| FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | ||
| AMOUNT_TYPE | VARCHAR2 | (4) | ||
| BOUNDARY_CODE | VARCHAR2 | (1) | ||
| TOLERANCE_PERCENTAGE | NUMBER | |||
| TOLERANCE_AMOUNT | NUMBER | |||
| OVERRIDE_AMOUNT | NUMBER | |||
| DR_CR_CODE | VARCHAR2 | (1) | ||
| ACCOUNT_TYPE | VARCHAR2 | (1) | ||
| ACCOUNT_CATEGORY_CODE | VARCHAR2 | (1) | ||
| EFFECT_ON_FUNDS_CODE | VARCHAR2 | (1) | ||
| RESULT_CODE | VARCHAR2 | (3) | ||
| BUDGET_POSTED_BALANCE | NUMBER | |||
| ACTUAL_POSTED_BALANCE | NUMBER | |||
| ENCUMBRANCE_POSTED_BALANCE | NUMBER | |||
| BUDGET_APPROVED_BALANCE | NUMBER | |||
| ACTUAL_APPROVED_BALANCE | NUMBER | |||
| ENCUMBRANCE_APPROVED_BALANCE | NUMBER | |||
| BUDGET_PENDING_BALANCE | NUMBER | |||
| ACTUAL_PENDING_BALANCE | NUMBER | |||
| ENCUMBRANCE_PENDING_BALANCE | NUMBER | |||
| REFERENCE1 | VARCHAR2 | (100) | ||
| REFERENCE2 | VARCHAR2 | (100) | ||
| REFERENCE3 | VARCHAR2 | (100) | ||
| REFERENCE4 | VARCHAR2 | (100) | ||
| REFERENCE5 | VARCHAR2 | (100) | ||
| JE_BATCH_NAME | VARCHAR2 | (100) | ||
| JE_BATCH_ID | NUMBER | (15) | ||
| JE_HEADER_ID | NUMBER | (15) | ||
| JE_LINE_NUM | NUMBER | (15) | ||
| JE_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
| REFERENCE6 | VARCHAR2 | (100) | ||
| REFERENCE7 | VARCHAR2 | (100) | ||
| REFERENCE8 | VARCHAR2 | (100) | ||
| REFERENCE9 | VARCHAR2 | (100) | ||
| REFERENCE10 | VARCHAR2 | (100) | ||
| REFERENCE11 | VARCHAR2 | (100) | ||
| REFERENCE12 | VARCHAR2 | (100) | ||
| REFERENCE13 | VARCHAR2 | (100) | ||
| REFERENCE14 | VARCHAR2 | (100) | ||
| REFERENCE15 | VARCHAR2 | (100) | ||
| REQUEST_ID | NUMBER | (15) | ||
| USSGL_PARENT_ID | NUMBER | (15) | ||
| USSGL_LINK_TO_PARENT_ID | NUMBER | (15) | ||
| EVENT_ID | NUMBER | (15) | ||
| AE_HEADER_ID | NUMBER | (15) | ||
| AE_LINE_NUM | NUMBER | (15) | ||
| BC_DATE | DATE | |||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (38) | ||
| SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (38) | ||
| SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (38) | ||
| SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (38) | ||
| SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (38) | ||
| SESSION_ID | NUMBER | (38) | Yes | |
| SERIAL_ID | NUMBER | (38) | Yes | |
| APPLICATION_ID | NUMBER | (15) | Yes | |
| ENTITY_ID | NUMBER | (15) | ||
| GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PACKET_ID
, LEDGER_ID
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, CODE_COMBINATION_ID
, ACTUAL_FLAG
, PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, CURRENCY_CODE
, STATUS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, USSGL_TRANSACTION_CODE
, ORIGINATING_ROWID
, ACCOUNT_SEGMENT_VALUE
, AUTOMATIC_ENCUMBRANCE_FLAG
, FUNDING_BUDGET_VERSION_ID
, FUNDS_CHECK_LEVEL_CODE
, AMOUNT_TYPE
, BOUNDARY_CODE
, TOLERANCE_PERCENTAGE
, TOLERANCE_AMOUNT
, OVERRIDE_AMOUNT
, DR_CR_CODE
, ACCOUNT_TYPE
, ACCOUNT_CATEGORY_CODE
, EFFECT_ON_FUNDS_CODE
, RESULT_CODE
, BUDGET_POSTED_BALANCE
, ACTUAL_POSTED_BALANCE
, ENCUMBRANCE_POSTED_BALANCE
, BUDGET_APPROVED_BALANCE
, ACTUAL_APPROVED_BALANCE
, ENCUMBRANCE_APPROVED_BALANCE
, BUDGET_PENDING_BALANCE
, ACTUAL_PENDING_BALANCE
, ENCUMBRANCE_PENDING_BALANCE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, JE_BATCH_NAME
, JE_BATCH_ID
, JE_HEADER_ID
, JE_LINE_NUM
, JE_LINE_DESCRIPTION
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, REFERENCE11
, REFERENCE12
, REFERENCE13
, REFERENCE14
, REFERENCE15
, REQUEST_ID
, USSGL_PARENT_ID
, USSGL_LINK_TO_PARENT_ID
, EVENT_ID
, AE_HEADER_ID
, AE_LINE_NUM
, BC_DATE
, SOURCE_DISTRIBUTION_TYPE
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SESSION_ID
, SERIAL_ID
, APPLICATION_ID
, ENTITY_ID
, GROUP_ID
FROM GL.GL_BC_PACKETS_HISTS#;
GL
GL_BC_PACKETS_HISTS
APPS
GL_BC_PACKETS_HISTS
|
|
|
|