[Home] [Help] [Dependency Information]

VIEW: APPS.GL_BC_PACKETS_V

Object Details

Object Name:	GL_BC_PACKETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_BC_PACKETS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      PACKET_ID
,      SET_OF_BOOKS_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
,      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
,      ENC_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      ENC_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      ACTUAL_PENDING_BALANCE
,      ENC_PENDING_BALANCE
,      BUDGET_TOTAL_BALANCE
,      ENC_TOTAL_BALANCE
,      ACTUAL_TOTAL_BALANCE
,      AVAIL_POSTED_BALANCE
,      AVAIL_APPROVED_BALANCE
,      AVAIL_PENDING_BALANCE
,      AVAIL_TOTAL_BALANCE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      JE_LINE_DESCRIPTION
,      USER_JE_CATEGORY_NAME
,      USER_JE_SOURCE_NAME
,      TRANSACTION_AMOUNT
,      ACTUAL_FLAG_MEANING
,      BUDGET_NAME
,      ENCUMBRANCE_TYPE
,      STATUS_CODE_MEANING
,      RESULT_CODE_MEANING
,      FUNDING_BUDGET_NAME
,      AMOUNT_TYPE_MEANING
,      BOUNDARY_MEANING
,      TEMPLATE
,      LEVEL_MEANING
,      ACCOUNT_TYPE_MEANING
,      EFFECT_ON_FUNDS_MEANING
,      BATCH_NAME
,      HEADER_NAME
FROM APPS.GL_BC_PACKETS_V;

Dependencies

[top of page]

APPS

GL_BC_PACKETS

GL_BUDGET_VERSIONS

GL_ENCUMBRANCE_TYPES

GL_JE_BATCHES

GL_JE_CATEGORIES

GL_JE_HEADERS

GL_JE_SOURCES

GL_LOOKUPS

GL_SUMMARY_TEMPLATES

APPS.GL_BC_PACKETS_V is not referenced by any database object