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


VIEW: APPS.CST_PAC_AEL_GL_INV_V

Object Details
Object Name: CST_PAC_AEL_GL_INV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PAC_AEL_GL_INV_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY NUMBER (15) Yes
COST_GROUP_ID NUMBER
Yes
COST_GROUP_NAME VARCHAR2 (10) Yes
COST_TYPE_ID NUMBER
Yes
COST_TYPE_NAME VARCHAR2 (10) Yes
MASTER_ORGANIZATION_ID NUMBER

PRIMARY_COST_METHOD NUMBER
Yes
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15) Yes
INVENTORY_ORGANIZATION_CODE VARCHAR2 (3)
INVENTORY_ORGANIZATION_ID NUMBER
Yes
TRX_CLASS_NAME VARCHAR2 (80) Yes
TRX_CLASS CHAR (7)
TRX_TYPE_NAME VARCHAR2 (80) Yes
TRX_TYPE_N NUMBER
Yes
TRX_NUMBER_DISPLAYED VARCHAR2 (40)
TRX_NUMBER_N NUMBER

TRX_DATE DATE
Yes
COMMENTS VARCHAR2 (240)
TRX_HDR_TABLE CHAR (3)
TRX_HDR_ID NUMBER

ACCT_LINE_TYPE_NAME VARCHAR2 (80) Yes
ACCT_LINE_TYPE VARCHAR2 (30)
CODE_COMBINATION_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15) Yes
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

ACCOUNTING_DATE DATE
Yes
GL_TRANSFER_STATUS_NAME VARCHAR2 (80) Yes
GL_TRANSFER_STATUS VARCHAR2 (1)
GL_BATCH_ID NUMBER

SOURCE_TABLE CHAR (3)
SOURCE_ID NUMBER

AEL_TABLE CHAR (3)
AE_LINE_REFERENCE VARCHAR2 (132)
AE_LINE_REFERENCE_INTERNAL VARCHAR2 (132)
INVENTORY_ITEM_ID NUMBER
Yes
INVENTORY_ITEM_REVISION VARCHAR2 (3)
TRX_UOM VARCHAR2 (3) Yes
TRX_QUANTITY NUMBER
Yes
UNIT_COST VARCHAR2 (40)
SUBINVENTORY VARCHAR2 (10)
INVENTORY_ITEM_LOCATOR_ID NUMBER

INVENTORY_ITEM_LOCATOR_NAME VARCHAR2 (50)
MFG_OPERATION_SEQ_NUM NUMBER

TRX_SOURCE_TYPE_NAME VARCHAR2 (30) Yes
TRX_SOURCE_TYPE_ID NUMBER
Yes
TRX_SOURCE_NAME VARCHAR2 (80)
TRX_SOURCE_ID NUMBER

TRX_REASON_NAME VARCHAR2 (30)
COST_ELEMENT_NAME VARCHAR2 (50)
COST_ELEMENT_ID NUMBER

JE_HEADER_ID NUMBER (15) Yes
JE_LINE_NUM NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT LEGAL_ENTITY
,      COST_GROUP_ID
,      COST_GROUP_NAME
,      COST_TYPE_ID
,      COST_TYPE_NAME
,      MASTER_ORGANIZATION_ID
,      PRIMARY_COST_METHOD
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      INVENTORY_ORGANIZATION_CODE
,      INVENTORY_ORGANIZATION_ID
,      TRX_CLASS_NAME
,      TRX_CLASS
,      TRX_TYPE_NAME
,      TRX_TYPE_N
,      TRX_NUMBER_DISPLAYED
,      TRX_NUMBER_N
,      TRX_DATE
,      COMMENTS
,      TRX_HDR_TABLE
,      TRX_HDR_ID
,      ACCT_LINE_TYPE_NAME
,      ACCT_LINE_TYPE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      ACCOUNTING_DATE
,      GL_TRANSFER_STATUS_NAME
,      GL_TRANSFER_STATUS
,      GL_BATCH_ID
,      SOURCE_TABLE
,      SOURCE_ID
,      AEL_TABLE
,      AE_LINE_REFERENCE
,      AE_LINE_REFERENCE_INTERNAL
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_REVISION
,      TRX_UOM
,      TRX_QUANTITY
,      UNIT_COST
,      SUBINVENTORY
,      INVENTORY_ITEM_LOCATOR_ID
,      INVENTORY_ITEM_LOCATOR_NAME
,      MFG_OPERATION_SEQ_NUM
,      TRX_SOURCE_TYPE_NAME
,      TRX_SOURCE_TYPE_ID
,      TRX_SOURCE_NAME
,      TRX_SOURCE_ID
,      TRX_REASON_NAME
,      COST_ELEMENT_NAME
,      COST_ELEMENT_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.CST_PAC_AEL_GL_INV_V;

Dependencies

[top of page]

APPS.CST_PAC_AEL_GL_INV_V references the following:

SchemaAPPS
SynonymCST_AE_HEADERS
SynonymCST_AE_LINES
SynonymCST_COST_ELEMENTS
SynonymCST_COST_GROUPS
SynonymCST_COST_GROUP_ASSIGNMENTS
SynonymCST_COST_TYPES
SynonymCST_LE_COST_TYPES
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
SynonymGL_PERIOD_STATUSES
ViewGL_SETS_OF_BOOKS
ViewMFG_LOOKUPS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_TRANSACTION_TYPES
SynonymMTL_TXN_SOURCE_TYPES
APPS.CST_PAC_AEL_GL_INV_V is referenced by following:

SchemaAPPS
ViewXLA_INV_AEL_GL_PAC_V