[Home] [Help] [Dependency Information]

VIEW: APPS.XLA_AR_REC_AEL_SL_V

Object Details

Object Name:	XLA_AR_REC_AEL_SL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XLA.XLA_AR_REC_AEL_SL_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 ACCOUNTED_CR
,      ACCOUNTED_DR
,      ACCOUNTING_DATE
,      ACCT_LINE_TYPE
,      ACCT_LINE_TYPE_NAME
,      AEH_ID
,      AEL_ID
,      AEL_TABLE
,      AE_LINE_REFERENCE
,      AE_LINE_REFERENCE_INTERNAL
,      APPLICATION_ID
,      CODE_COMBINATION_ID
,      COMMENTS
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      ENTERED_CR
,      ENTERED_DR
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_STATUS_NAME
,      TRANSFER_STATUS_DETAIL_NAME
,      TRANSFER_SYSTEM_NAME
,      TRANSFER_SYSTEM
,      GL_TRANSFER_FROM_TO_NAME
,      ACCOUNTING_COMPLETE
,      ACCOUNTING_COMPLETE_NAME
,      ORG_ID
,      SET_OF_BOOKS_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_CODE
,      THIRD_PARTY_ID
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_SUB_ID
,      THIRD_PARTY_SUB_NAME
,      THIRD_PARTY_TYPE
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_DATE
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      TRX_NUMBER_C
,      TRX_NUMBER_DISPLAYED
,      TRX_NUMBER_N
,      TRX_TYPE_C
,      TRX_TYPE_N
,      TRX_TYPE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACCOUNTING_RULE_NAME
,      INVENTORY_ITEM_ID
,      SALESREP_NAME
,      SALES_ORDER_NUMBER
,      TAX_EXEMPT_NUMBER
,      TAX_RATE
,      TRX_DETAIL_LINE_NUMBER
,      TRX_LINE_NUMBER
,      TRX_LINE_TYPE
,      TRX_LINE_TYPE_NAME
,      TRX_QUANTITY
,      TRX_SOURCE_ID
,      TRX_SOURCE_NAME
,      TRX_UOM
,      UNIT_SELLING_PRICE
,      AR_ADJUSTMENT_CREATION_TYPE
,      AR_ADJUSTMENT_TYPE
,      PAYMENT_NUMBER
,      PAYMENT_DATE
,      CHARGEBACK_NUMBER
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      APPLIED_TO_TRX_HDR_NUMBER_DISP
,      APPLIED_TO_TRX_HDR_NUMBER_C
,      APPLIED_TO_TRX_HDR_DATE
,      PAYMENT_DEPOSIT_DATE
,      TRX_HDR_CURRENCY
,      BANK_ACCOUNT_NAME
,      REVERSAL_COMMENTS
,      REVERSAL_DATE
,      APPLICATION_DATE
,      APPLIED_TO_TRX_HDR_CURRENCY
,      APPLIED_TO_TRX_LINE_TYPE_NAME
,      APPLIED_TO_TRX_LINE_TYPE
,      APPLIED_TO_TRX_LINE_NUMBER
,      AR_ACTIVITY_NAME
,      DISTRIBUTION_SET_NAME
,      ACCOUNTING_EVENT_NUMBER
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_EVENT_TYPE_NAME
,      ACCOUNTING_LINE_NUMBER
,      BANK_STATEMENT_DOC_SEQ_ID
,      BANK_STATEMENT_DOC_SEQ_NAME
,      BANK_STATEMENT_DOC_SEQ_VALUE
,      BANK_STATEMENT_LINE_NUMBER
,      BANK_STATEMENT_NUMBER
,      PAYMENT_RECON_CURRENCY
,      PAYMENT_CLEARED_DATE
,      USER_JE_CATEGORY_NAME
,      JE_CATEGORY
,      AEH_ACCOUNTING_ERROR_NAME
,      AEH_ACCOUNTING_ERROR_CODE
,      AEL_ACCOUNTING_ERROR_NAME
,      AEL_ACCOUNTING_ERROR_CODE
,      PA_ACCRUE_THRU_DATE
,      PA_AGREEMENT_NUM
,      PA_CUSTOMER_NAME
,      PA_CUSTOMER_NUMBER
,      PA_DRI_NUMBER
,      PA_EI_EV_ORG
,      PA_EI_EV_TYPE
,      PA_EMPLOYEE_NAME
,      PA_EMPLOYEE_NUM
,      PA_EVENT_NUM
,      PA_GL_TRANSFER_DATE
,      PA_LINE_NUMBER
,      PA_NL_RESOURCE
,      PA_NL_RESOURCE_ORG
,      PA_PERIOD_DATE
,      PA_PROJECT_ID
,      PA_PROJECT_NAME
,      PA_PROJECT_NUM
,      PA_QUANTITY
,      PA_SUPPLIER_NAME
,      PA_SUPPLIER_NUM
,      PA_TASK_NAME
,      PA_TASK_NUM
,      PA_TRANSFER_TO_GL
,      PA_TRANS_ID
,      PA_UOM
,      PA_VIEW_LABOR_COST
,      PRVDR_ORGANIZATION_NAME
,      RECVR_ORGANIZATION_NAME
,      PRVDR_OU_NAME
,      RECVR_OU_NAME
,      CC_TYPE_NAME
,      CC_TYPE
,      CC_PROC_METHOD_NAME
,      CC_PROC_METHOD
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_FLEX_STRUCTURE
,      ASSET_CATEGORY_ID
,      ASSET_KEY_FLEX_STRUCTURE
,      ASSET_KEY_CCID
,      COST_ELEMENT_ID
,      COST_ELEMENT_NAME
,      GL_BATCH_ID
,      INVENTORY_ITEM_LOCATOR_ID
,      INVENTORY_ITEM_LOCATOR_NAME
,      INVENTORY_ITEM_REVISION
,      ITEM_DESCRIPTION
,      INVENTORY_ORGANIZATION_CODE
,      INVENTORY_ORGANIZATION_ID
,      MFG_OPERATION_SEQ_NUM
,      SUBINVENTORY
,      TRX_REASON_NAME
,      TRX_SOURCE_TYPE_ID
,      TRX_SOURCE_TYPE_NAME
,      UNIT_COST
,      COST_TYPE_ID
,      COST_TYPE_NAME
,      BOM_DEPARTMENT_CODE
,      BOM_DEPARTMENT_NAME
,      WIP_ASSEMBLY
,      WIP_BASIS
,      WIP_FLOW_SCHEDULE_NUMBER
,      WIP_JOB_ID
,      WIP_JOB_NAME
,      WIP_LINE_CODE
,      WIP_LINE_ID
,      WIP_RESOURCE_ID
,      WIP_RESOURCE_NAME
,      WIP_RESOURCE_SEQ_NUM
,      PO_LINE_NUM
,      PO_ORDER_NUMBER
,      PO_ORDER_RELEASE_NUM
,      PO_ORDER_TYPE
,      RCV_RECEIPT_NUM
,      RCV_SHIPMENT_HEADER_ID
,      UNIT_PRICE
,      PRICE_OVERRIDE
,      PO_ORDER_SHIPMENT_NUM
,      PO_ORDER_DISTRIBUTION_NUM
FROM APPS.XLA_AR_REC_AEL_SL_V;

Dependencies

[top of page]

APPS

ARPT_SQL_FUNC_UTIL - show dependent code

AR_AEL_SL_REC_V

FND_ACCESS_CONTROL_UTIL - show dependent code

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

MO_GLOBAL - show dependent code

XTR_USER_ACCESS - show dependent code

APPS.XLA_AR_REC_AEL_SL_V is not referenced by any database object