[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XLA_AR_REC_AEL_SL_MRC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XLA.XLA_AR_REC_AEL_SL_MRC_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNTED_CR | NUMBER | |||
| ACCOUNTED_DR | NUMBER | |||
| ACCOUNTING_DATE | DATE | |||
| ACCT_LINE_TYPE | VARCHAR2 | (30) | ||
| ACCT_LINE_TYPE_NAME | VARCHAR2 | (4000) | ||
| AEH_ID | NUMBER | |||
| AEL_ID | NUMBER | (15) | ||
| AEL_TABLE | CHAR | (3) | ||
| AE_LINE_REFERENCE | VARCHAR2 | (4000) | ||
| AE_LINE_REFERENCE_INTERNAL | VARCHAR2 | (4000) | ||
| APPLICATION_ID | NUMBER | |||
| CODE_COMBINATION_ID | NUMBER | (15) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_USER_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| DOC_SEQUENCE_ID | NUMBER | (15) | ||
| DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
| DOC_SEQUENCE_VALUE | NUMBER | (15) | ||
| ENTERED_CR | NUMBER | |||
| ENTERED_DR | NUMBER | |||
| GL_TRANSFER_STATUS | VARCHAR2 | (1) | ||
| GL_TRANSFER_STATUS_NAME | VARCHAR2 | (4000) | ||
| TRANSFER_STATUS_DETAIL_NAME | VARCHAR2 | (0) | ||
| TRANSFER_SYSTEM_NAME | VARCHAR2 | (0) | ||
| TRANSFER_SYSTEM | VARCHAR2 | (0) | ||
| GL_TRANSFER_FROM_TO_NAME | VARCHAR2 | (0) | ||
| ACCOUNTING_COMPLETE | VARCHAR2 | (0) | ||
| ACCOUNTING_COMPLETE_NAME | VARCHAR2 | (0) | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| SET_OF_BOOKS_ID | NUMBER | (15) | ||
| SOURCE_ID | NUMBER | (15) | ||
| SOURCE_TABLE | VARCHAR2 | (10) | ||
| TAXABLE_ENTERED_DR | NUMBER | |||
| TAXABLE_ENTERED_CR | NUMBER | |||
| TAXABLE_ACCOUNTED_DR | NUMBER | |||
| TAXABLE_ACCOUNTED_CR | NUMBER | |||
| TAX_CODE | VARCHAR2 | (50) | ||
| THIRD_PARTY_ID | NUMBER | (15) | ||
| THIRD_PARTY_NAME | VARCHAR2 | (50) | ||
| THIRD_PARTY_NUMBER | VARCHAR2 | (30) | ||
| THIRD_PARTY_SUB_ID | NUMBER | (15) | ||
| THIRD_PARTY_SUB_NAME | VARCHAR2 | (40) | ||
| THIRD_PARTY_TYPE | CHAR | (1) | ||
| TRX_CLASS | VARCHAR2 | (20) | ||
| TRX_CLASS_NAME | VARCHAR2 | (4000) | ||
| TRX_DATE | DATE | |||
| TRX_HDR_ID | NUMBER | (15) | ||
| TRX_HDR_TABLE | CHAR | (2) | ||
| TRX_NUMBER_C | VARCHAR2 | (30) | ||
| TRX_NUMBER_DISPLAYED | VARCHAR2 | (30) | ||
| TRX_NUMBER_N | NUMBER | |||
| TRX_TYPE_C | VARCHAR2 | (0) | ||
| TRX_TYPE_N | NUMBER | (15) | ||
| TRX_TYPE_NAME | VARCHAR2 | (30) | ||
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| ACCOUNTING_RULE_NAME | VARCHAR2 | (0) | ||
| INVENTORY_ITEM_ID | NUMBER | |||
| SALESREP_NAME | VARCHAR2 | (0) | ||
| SALES_ORDER_NUMBER | VARCHAR2 | (0) | ||
| TAX_EXEMPT_NUMBER | VARCHAR2 | (0) | ||
| TAX_RATE | NUMBER | |||
| TRX_DETAIL_LINE_NUMBER | NUMBER | |||
| TRX_LINE_NUMBER | NUMBER | |||
| TRX_LINE_TYPE | VARCHAR2 | (0) | ||
| TRX_LINE_TYPE_NAME | VARCHAR2 | (0) | ||
| TRX_QUANTITY | NUMBER | |||
| TRX_SOURCE_ID | NUMBER | |||
| TRX_SOURCE_NAME | VARCHAR2 | (0) | ||
| TRX_UOM | VARCHAR2 | (0) | ||
| UNIT_SELLING_PRICE | NUMBER | |||
| AR_ADJUSTMENT_CREATION_TYPE | VARCHAR2 | (0) | ||
| AR_ADJUSTMENT_TYPE | VARCHAR2 | (0) | ||
| PAYMENT_NUMBER | VARCHAR2 | (0) | ||
| PAYMENT_DATE | DATE | |||
| CHARGEBACK_NUMBER | VARCHAR2 | (0) | ||
| APPLIED_TO_TRX_HDR_TABLE | VARCHAR2 | (2) | ||
| APPLIED_TO_TRX_HDR_ID | NUMBER | |||
| APPLIED_TO_TRX_HDR_NUMBER_DISP | VARCHAR2 | (20) | ||
| APPLIED_TO_TRX_HDR_NUMBER_C | VARCHAR2 | (20) | ||
| APPLIED_TO_TRX_HDR_DATE | DATE | |||
| PAYMENT_DEPOSIT_DATE | DATE | |||
| TRX_HDR_CURRENCY | VARCHAR2 | (15) | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | (100) | ||
| REVERSAL_COMMENTS | VARCHAR2 | (240) | ||
| REVERSAL_DATE | DATE | |||
| APPLICATION_DATE | DATE | |||
| APPLIED_TO_TRX_HDR_CURRENCY | VARCHAR2 | (15) | ||
| 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) | ||
| ACCOUNTING_EVENT_NUMBER | NUMBER | |||
| ACCOUNTING_EVENT_TYPE | VARCHAR2 | (0) | ||
| ACCOUNTING_EVENT_TYPE_NAME | VARCHAR2 | (0) | ||
| ACCOUNTING_LINE_NUMBER | NUMBER | |||
| BANK_STATEMENT_DOC_SEQ_ID | NUMBER | |||
| BANK_STATEMENT_DOC_SEQ_NAME | VARCHAR2 | (0) | ||
| BANK_STATEMENT_DOC_SEQ_VALUE | NUMBER | |||
| BANK_STATEMENT_LINE_NUMBER | NUMBER | |||
| BANK_STATEMENT_NUMBER | VARCHAR2 | (0) | ||
| PAYMENT_RECON_CURRENCY | VARCHAR2 | (0) | ||
| PAYMENT_CLEARED_DATE | DATE | |||
| USER_JE_CATEGORY_NAME | VARCHAR2 | (0) | ||
| JE_CATEGORY | VARCHAR2 | (0) | ||
| AEH_ACCOUNTING_ERROR_NAME | VARCHAR2 | (0) | ||
| AEH_ACCOUNTING_ERROR_CODE | VARCHAR2 | (0) | ||
| AEL_ACCOUNTING_ERROR_NAME | VARCHAR2 | (0) | ||
| AEL_ACCOUNTING_ERROR_CODE | VARCHAR2 | (0) | ||
| PA_ACCRUE_THRU_DATE | DATE | |||
| PA_AGREEMENT_NUM | VARCHAR2 | (0) | ||
| PA_CUSTOMER_NAME | VARCHAR2 | (0) | ||
| PA_CUSTOMER_NUMBER | NUMBER | |||
| PA_DRI_NUMBER | NUMBER | |||
| PA_EI_EV_ORG | VARCHAR2 | (0) | ||
| PA_EI_EV_TYPE | VARCHAR2 | (0) | ||
| PA_EMPLOYEE_NAME | VARCHAR2 | (0) | ||
| PA_EMPLOYEE_NUM | VARCHAR2 | (0) | ||
| PA_EVENT_NUM | NUMBER | |||
| PA_GL_TRANSFER_DATE | DATE | |||
| PA_LINE_NUMBER | NUMBER | |||
| PA_NL_RESOURCE | VARCHAR2 | (0) | ||
| PA_NL_RESOURCE_ORG | VARCHAR2 | (0) | ||
| PA_PERIOD_DATE | DATE | |||
| PA_PROJECT_ID | NUMBER | |||
| PA_PROJECT_NAME | VARCHAR2 | (0) | ||
| PA_PROJECT_NUM | VARCHAR2 | (0) | ||
| PA_QUANTITY | NUMBER | |||
| PA_SUPPLIER_NAME | VARCHAR2 | (0) | ||
| PA_SUPPLIER_NUM | VARCHAR2 | (0) | ||
| PA_TASK_NAME | VARCHAR2 | (0) | ||
| PA_TASK_NUM | VARCHAR2 | (0) | ||
| PA_TRANSFER_TO_GL | VARCHAR2 | (0) | ||
| PA_TRANS_ID | NUMBER | |||
| PA_UOM | VARCHAR2 | (0) | ||
| PA_VIEW_LABOR_COST | VARCHAR2 | (0) | ||
| PRVDR_ORGANIZATION_NAME | VARCHAR2 | (0) | ||
| RECVR_ORGANIZATION_NAME | VARCHAR2 | (0) | ||
| PRVDR_OU_NAME | VARCHAR2 | (0) | ||
| RECVR_OU_NAME | VARCHAR2 | (0) | ||
| CC_TYPE_NAME | VARCHAR2 | (0) | ||
| CC_TYPE | VARCHAR2 | (0) | ||
| CC_PROC_METHOD_NAME | VARCHAR2 | (0) | ||
| CC_PROC_METHOD | VARCHAR2 | (0) | ||
| ASSET_ID | NUMBER | |||
| ASSET_NUMBER | VARCHAR2 | (0) | ||
| ASSET_DESCRIPTION | VARCHAR2 | (0) | ||
| ASSET_BOOK_TYPE_CODE | VARCHAR2 | (0) | ||
| ASSET_CATEGORY_FLEX_STRUCTURE | NUMBER | |||
| ASSET_CATEGORY_ID | NUMBER | |||
| ASSET_KEY_FLEX_STRUCTURE | NUMBER | |||
| ASSET_KEY_CCID | NUMBER | |||
| COST_ELEMENT_ID | NUMBER | |||
| COST_ELEMENT_NAME | VARCHAR2 | (0) | ||
| GL_BATCH_ID | NUMBER | |||
| INVENTORY_ITEM_LOCATOR_ID | NUMBER | |||
| INVENTORY_ITEM_LOCATOR_NAME | VARCHAR2 | (0) | ||
| INVENTORY_ITEM_REVISION | VARCHAR2 | (0) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (0) | ||
| INVENTORY_ORGANIZATION_CODE | VARCHAR2 | (0) | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | |||
| MFG_OPERATION_SEQ_NUM | NUMBER | |||
| SUBINVENTORY | VARCHAR2 | (0) | ||
| TRX_REASON_NAME | VARCHAR2 | (0) | ||
| TRX_SOURCE_TYPE_ID | NUMBER | |||
| TRX_SOURCE_TYPE_NAME | VARCHAR2 | (0) | ||
| UNIT_COST | VARCHAR2 | (0) | ||
| COST_TYPE_ID | NUMBER | |||
| COST_TYPE_NAME | VARCHAR2 | (0) | ||
| BOM_DEPARTMENT_CODE | VARCHAR2 | (0) | ||
| BOM_DEPARTMENT_NAME | VARCHAR2 | (0) | ||
| WIP_ASSEMBLY | VARCHAR2 | (0) | ||
| WIP_BASIS | VARCHAR2 | (0) | ||
| WIP_FLOW_SCHEDULE_NUMBER | VARCHAR2 | (0) | ||
| WIP_JOB_ID | NUMBER | |||
| WIP_JOB_NAME | VARCHAR2 | (0) | ||
| WIP_LINE_CODE | VARCHAR2 | (0) | ||
| WIP_LINE_ID | NUMBER | |||
| WIP_RESOURCE_ID | NUMBER | |||
| WIP_RESOURCE_NAME | VARCHAR2 | (0) | ||
| WIP_RESOURCE_SEQ_NUM | NUMBER | |||
| PO_LINE_NUM | NUMBER | |||
| PO_ORDER_NUMBER | VARCHAR2 | (0) | ||
| PO_ORDER_RELEASE_NUM | NUMBER | |||
| PO_ORDER_TYPE | VARCHAR2 | (0) | ||
| RCV_RECEIPT_NUM | VARCHAR2 | (0) | ||
| RCV_SHIPMENT_HEADER_ID | NUMBER | |||
| UNIT_PRICE | NUMBER | |||
| PRICE_OVERRIDE | NUMBER | |||
| PO_ORDER_SHIPMENT_NUM | NUMBER | |||
| PO_ORDER_DISTRIBUTION_NUM | NUMBER |
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_MRC_V;
APPS
ARPT_SQL_FUNC_UTIL
- show dependent code
AR_AEL_SL_REC_MRC_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_MRC_V is not referenced by any database object
|
|
|
|