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


VIEW: APPS.CST_PAC_AEL_GL_WIP_V

Object Details
Object Name: CST_PAC_AEL_GL_WIP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PAC_AEL_GL_WIP_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)
COST_GROUP_ID NUMBER

COST_GROUP_NAME VARCHAR2 (10)
COST_TYPE_ID NUMBER

COST_TYPE_NAME VARCHAR2 (10)
PRIMARY_COST_METHOD NUMBER

MASTER_ITEM_ORG_ID NUMBER

APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
INVENTORY_ORGANIZATION_CODE VARCHAR2 (3)
INVENTORY_ORGANIZATION_ID NUMBER

TRX_CLASS_NAME VARCHAR2 (80)
TRX_CLASS CHAR (7)
TRX_TYPE_NAME VARCHAR2 (80)
TRX_TYPE_N NUMBER

TRX_NUMBER_DISPLAYED VARCHAR2 (40)
TRX_NUMBER_N NUMBER

TRX_DATE DATE

COMMENTS VARCHAR2 (240)
TRX_HDR_TABLE VARCHAR2 (10)
TRX_HDR_ID NUMBER

ACCT_LINE_TYPE_NAME VARCHAR2 (80)
ACCT_LINE_TYPE VARCHAR2 (30)
CODE_COMBINATION_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15)
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

GL_TRANSFER_STATUS_NAME VARCHAR2 (80)
GL_TRANSFER_STATUS VARCHAR2 (1)
GL_BATCH_ID NUMBER

SOURCE_TABLE VARCHAR2 (30)
SOURCE_ID NUMBER (15)
AEL_TABLE CHAR (3)
AE_LINE_REFERENCE VARCHAR2 (240)
AE_LINE_REFERENCE_INTERNAL VARCHAR2 (132)
TRX_UOM VARCHAR2 (3)
TRX_QUANTITY NUMBER

UNIT_COST VARCHAR2 (40)
MFG_OPERATION_SEQ_NUM NUMBER

BOM_DEPARTMENT_CODE VARCHAR2 (10)
BOM_DEPARTMENT_NAME VARCHAR2 (240)
WIP_RESOURCE_SEQ_NUM NUMBER

TRX_SOURCE_NAME VARCHAR2 (20)
WIP_JOB_ID NUMBER

WIP_JOB_NAME VARCHAR2 (240)
WIP_LINE_ID NUMBER

WIP_LINE_CODE VARCHAR2 (10)
WIP_ASSEMBLY VARCHAR2 (40)
WIP_BASIS VARCHAR2 (80)
WIP_RESOURCE_ID NUMBER

WIP_RESOURCE_NAME VARCHAR2 (10)
WIP_FLOW_SCHEDULE_NUMBER VARCHAR2 (30)
TRX_REASON_NAME VARCHAR2 (30)
COST_ELEMENT_ID NUMBER

COST_ELEMENT_NAME VARCHAR2 (50)
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
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
,      PRIMARY_COST_METHOD
,      MASTER_ITEM_ORG_ID
,      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
,      TRX_UOM
,      TRX_QUANTITY
,      UNIT_COST
,      MFG_OPERATION_SEQ_NUM
,      BOM_DEPARTMENT_CODE
,      BOM_DEPARTMENT_NAME
,      WIP_RESOURCE_SEQ_NUM
,      TRX_SOURCE_NAME
,      WIP_JOB_ID
,      WIP_JOB_NAME
,      WIP_LINE_ID
,      WIP_LINE_CODE
,      WIP_ASSEMBLY
,      WIP_BASIS
,      WIP_RESOURCE_ID
,      WIP_RESOURCE_NAME
,      WIP_FLOW_SCHEDULE_NUMBER
,      TRX_REASON_NAME
,      COST_ELEMENT_ID
,      COST_ELEMENT_NAME
,      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_WIP_V;

Dependencies

[top of page]

APPS.CST_PAC_AEL_GL_WIP_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
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
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_TRANSACTION_REASONS
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPO_HEADERS
SynonymWIP_ENTITIES
SynonymWIP_FLOW_SCHEDULES
SynonymWIP_LINES
SynonymWIP_TRANSACTIONS
APPS.CST_PAC_AEL_GL_WIP_V is referenced by following:

SchemaAPPS
ViewXLA_WIP_AEL_GL_PAC_V