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


VIEW: APPS.CST_PAC_AEL_GL_RCV_V

Object Details
Object Name: CST_PAC_AEL_GL_RCV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PAC_AEL_GL_RCV_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)
MASTER_ORGANIZATION_ID NUMBER

PRIMARY_COST_METHOD NUMBER

JE_CATEGORY VARCHAR2 (30)
USER_JE_CATEGORY_NAME VARCHAR2 (25)
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
ORG_ID NUMBER

INVENTORY_ORGANIZATION_CODE VARCHAR2 (3)
INVENTORY_ORGANIZATION_ID NUMBER

TRX_CLASS_NAME VARCHAR2 (80)
TRX_CLASS CHAR (7)
TRX_TYPE_NAME VARCHAR2 (240)
TRX_TYPE_C VARCHAR2 (30)
TRX_DATE DATE

COMMENTS VARCHAR2 (240)
TRX_HDR_TABLE CHAR (3)
TRX_HDR_ID NUMBER

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

THIRD_PARTY_TYPE CHAR (1)
THIRD_PARTY_ID NUMBER

THIRD_PARTY_NUMBER VARCHAR2 (30)
THIRD_PARTY_NAME VARCHAR2 (240)
THIRD_PARTY_SUB_ID NUMBER

THIRD_PARTY_SUB_NAME VARCHAR2 (15)
ACCOUNTING_DATE DATE

GL_TRANSFER_STATUS_NAME VARCHAR2 (80)
GL_TRANSFER_STATUS CHAR (1)
SOURCE_TABLE CHAR (3)
SOURCE_ID NUMBER

AEL_TABLE CHAR (3)
AE_LINE_REFERENCE VARCHAR2 (80)
AE_LINE_REFERENCE_INTERNAL VARCHAR2 (80)
RCV_RECEIPT_NUM VARCHAR2 (30)
RCV_SHIPMENT_HEADER_ID NUMBER

PO_ORDER_NUMBER VARCHAR2 (20)
PO_ORDER_TYPE VARCHAR2 (80)
PO_LINE_NUM NUMBER

INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
TRX_UOM VARCHAR2 (25)
TRX_QUANTITY NUMBER

UNIT_PRICE NUMBER

PO_ORDER_RELEASE_NUM NUMBER

SUBINVENTORY VARCHAR2 (10)
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

PO_ORDER_SHIPMENT_NUM NUMBER

PO_ORDER_DISTRIBUTION_NUM NUMBER

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
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      INVENTORY_ORGANIZATION_CODE
,      INVENTORY_ORGANIZATION_ID
,      TRX_CLASS_NAME
,      TRX_CLASS
,      TRX_TYPE_NAME
,      TRX_TYPE_C
,      TRX_DATE
,      COMMENTS
,      TRX_HDR_TABLE
,      TRX_HDR_ID
,      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
,      THIRD_PARTY_TYPE
,      THIRD_PARTY_ID
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_NAME
,      THIRD_PARTY_SUB_ID
,      THIRD_PARTY_SUB_NAME
,      ACCOUNTING_DATE
,      GL_TRANSFER_STATUS_NAME
,      GL_TRANSFER_STATUS
,      SOURCE_TABLE
,      SOURCE_ID
,      AEL_TABLE
,      AE_LINE_REFERENCE
,      AE_LINE_REFERENCE_INTERNAL
,      RCV_RECEIPT_NUM
,      RCV_SHIPMENT_HEADER_ID
,      PO_ORDER_NUMBER
,      PO_ORDER_TYPE
,      PO_LINE_NUM
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_REVISION
,      ITEM_DESCRIPTION
,      TRX_UOM
,      TRX_QUANTITY
,      UNIT_PRICE
,      PO_ORDER_RELEASE_NUM
,      SUBINVENTORY
,      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
,      PO_ORDER_SHIPMENT_NUM
,      PO_ORDER_DISTRIBUTION_NUM
FROM APPS.CST_PAC_AEL_GL_RCV_V;

Dependencies

[top of page]

APPS.CST_PAC_AEL_GL_RCV_V references the following:

SchemaAPPS
SynonymCST_AE_HEADERS
SynonymCST_AE_LINES
SynonymCST_COST_GROUPS
SynonymCST_COST_GROUP_ASSIGNMENTS
SynonymCST_COST_TYPES
SynonymCST_LE_COST_TYPES
ViewCST_ORGANIZATION_DEFINITIONS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_CATEGORIES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_ACCOUNTING_EVENTS
SynonymRCV_ACCOUNTING_EVENT_TYPES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS
APPS.CST_PAC_AEL_GL_RCV_V is referenced by following:

SchemaAPPS
ViewXLA_PO_AEL_GL_PAC_V