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


VIEW: APPS.AR_AEL_GL_CB_REC_V

Object Details
Object Name: AR_AEL_GL_CB_REC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_AEL_GL_CB_REC_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
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
ORG_ID NUMBER (15)
TRX_CLASS VARCHAR2 (20)
TRX_CLASS_NAME VARCHAR2 (80)
TRX_TYPE_N NUMBER (15)
TRX_TYPE_NAME VARCHAR2 (30)
TRX_NUMBER_DISPLAYED VARCHAR2 (30)
TRX_NUMBER_C VARCHAR2 (30)
TRX_DATE DATE

COMMENTS VARCHAR2 (2000)
DOC_SEQUENCE_ID NUMBER (15)
DOC_SEQUENCE_NAME VARCHAR2 (30)
DOC_SEQUENCE_VALUE NUMBER (15)
TRX_HDR_TABLE CHAR (2)
TRX_HDR_ID NUMBER (15)
ACCT_LINE_TYPE VARCHAR2 (30)
ACCT_LINE_TYPE_NAME VARCHAR2 (80)
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 (50)
THIRD_PARTY_SUB_ID NUMBER

THIRD_PARTY_SUB_NAME VARCHAR2 (40)
ACCOUNTING_DATE DATE

GL_TRANSFER_STATUS_NAME VARCHAR2 (80)
GL_TRANSFER_STATUS VARCHAR2 (1)
SOURCE_TABLE VARCHAR2 (10)
SOURCE_ID NUMBER (15)
AEL_ID NUMBER (15)
AEL_TABLE VARCHAR2 (3)
AE_LINE_REFERENCE VARCHAR2 (182)
AE_LINE_REFERENCE_INTERNAL VARCHAR2 (111)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ACCOUNTING_BASIS CHAR (4)
TAX_CODE VARCHAR2 (0)
TAX_CODE_ID NUMBER

TAX_LINK_ID NUMBER

TAXABLE_ENTERED_DR NUMBER

TAXABLE_ENTERED_CR NUMBER

TAXABLE_ACCOUNTED_DR NUMBER

TAXABLE_ACCOUNTED_CR NUMBER

TRX_HDR_CURRENCY VARCHAR2 (15)
BANK_ACCOUNT_NAME VARCHAR2 (100)
REVERSAL_COMMENTS VARCHAR2 (240)
REVERSAL_DATE DATE

APPLICATION_DATE DATE

PAYMENT_DEPOSIT_DATE DATE

APPLIED_TO_TRX_HDR_TABLE VARCHAR2 (2)
APPLIED_TO_TRX_HDR_ID NUMBER

APPLIED_TO_TRX_HDR_NUMBER_C VARCHAR2 (20)
APPLIED_TO_TRX_HDR_NUMBER_DISP VARCHAR2 (20)
APPLIED_TO_TRX_HDR_CURRENCY VARCHAR2 (15)
APPLIED_TO_TRX_HDR_DATE DATE

APPLIED_TO_TRX_LINE_TYPE_NAME VARCHAR2 (80)
APPLIED_TO_TRX_LINE_TYPE VARCHAR2 (20)
APPLIED_TO_TRX_LINE_NUMBER NUMBER

AR_ACTIVITY_NAME VARCHAR2 (50)
DISTRIBUTION_SET_NAME VARCHAR2 (50)
Query Text

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


SELECT JE_HEADER_ID
,      JE_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_TYPE_N
,      TRX_TYPE_NAME
,      TRX_NUMBER_DISPLAYED
,      TRX_NUMBER_C
,      TRX_DATE
,      COMMENTS
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      TRX_HDR_TABLE
,      TRX_HDR_ID
,      ACCT_LINE_TYPE
,      ACCT_LINE_TYPE_NAME
,      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_ID
,      AEL_TABLE
,      AE_LINE_REFERENCE
,      AE_LINE_REFERENCE_INTERNAL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_BASIS
,      TAX_CODE
,      TAX_CODE_ID
,      TAX_LINK_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TRX_HDR_CURRENCY
,      BANK_ACCOUNT_NAME
,      REVERSAL_COMMENTS
,      REVERSAL_DATE
,      APPLICATION_DATE
,      PAYMENT_DEPOSIT_DATE
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      APPLIED_TO_TRX_HDR_NUMBER_C
,      APPLIED_TO_TRX_HDR_NUMBER_DISP
,      APPLIED_TO_TRX_HDR_CURRENCY
,      APPLIED_TO_TRX_HDR_DATE
,      APPLIED_TO_TRX_LINE_TYPE_NAME
,      APPLIED_TO_TRX_LINE_TYPE
,      APPLIED_TO_TRX_LINE_NUMBER
,      AR_ACTIVITY_NAME
,      DISTRIBUTION_SET_NAME
FROM APPS.AR_AEL_GL_CB_REC_V;

Dependencies

[top of page]

APPS.AR_AEL_GL_CB_REC_V references the following:

SchemaAPPS
SynonymAR_CASH_BASIS_DISTS_ALL
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_CASH_RECEIPT_HISTORY_ALL
SynonymAR_DISTRIBUTIONS_ALL
SynonymAR_DISTRIBUTION_SETS_ALL
ViewAR_LOOKUPS
SynonymAR_MISC_CASH_DISTRIBUTIONS_ALL
SynonymAR_RECEIPT_METHODS
SynonymAR_RECEIVABLES_TRX_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymAR_SYSTEM_PARAMETERS_ALL
SynonymCE_BANK_ACCOUNTS
ViewCE_BANK_ACCT_USES
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
SynonymFND_DOCUMENT_SEQUENCES
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_HEADERS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_CUST_TRX_TYPES_ALL
PL/SQL PackageXTR_USER_ACCESS - show dependent code
APPS.AR_AEL_GL_CB_REC_V is referenced by following:

SchemaAPPS
ViewAR_AEL_GL_REC_ALL_V