[Home] [Help] [Dependency Information]

VIEW: APPS.AR_RECEIVABLE_APPLICATIONS_V

Object Details

Object Name:	AR_RECEIVABLE_APPLICATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_RECEIVABLE_APPLICATIONS_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 ROW_ID
,      CASH_RECEIPT_ID
,      CUSTOMER_TRX_ID
,      CM_CUSTOMER_TRX_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      RECEIPT_NUMBER
,      APPLIED_FLAG
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      TRX_NUMBER
,      INSTALLMENT
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      DISCOUNT
,      DISCOUNTS_EARNED
,      DISCOUNTS_UNEARNED
,      DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
,      AMOUNT_DUE_REMAINING
,      DUE_DATE
,      STATUS
,      TERM_ID
,      TRX_CLASS_NAME
,      TRX_CLASS_CODE
,      TRX_TYPE_NAME
,      CUST_TRX_TYPE_ID
,      TRX_DATE
,      LOCATION_NAME
,      BILL_TO_SITE_USE_ID
,      DAYS_LATE
,      LINE_NUMBER
,      CUSTOMER_TRX_LINE_ID
,      APPLY_DATE
,      GL_DATE
,      GL_POSTED_DATE
,      REVERSAL_GL_DATE
,      EXCHANGE_RATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_IN_DISPUTE
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      ACCTD_AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_AMOUNT_APPLIED_FROM
,      EXCHANGE_GAIN_LOSS
,      DISCOUNT_REMAINING
,      CALC_DISCOUNT_ON_LINES_FLAG
,      PARTIAL_DISCOUNT_FLAG
,      ALLOW_OVERAPPLICATION_FLAG
,      NATURAL_APPLICATION_ONLY_FLAG
,      CREATION_SIGN
,      APPLIED_PAYMENT_SCHEDULE_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      PURCHASE_ORDER
,      TRX_DOC_SEQUENCE_ID
,      TRX_DOC_SEQUENCE_VALUE
,      TRX_BATCH_SOURCE_NAME
,      AMOUNT_ADJUSTED
,      AMOUNT_ADJUSTED_PENDING
,      AMOUNT_LINE_ITEMS_REMAINING
,      FREIGHT_ORIGINAL
,      FREIGHT_REMAINING
,      RECEIVABLES_CHARGES_REMAINING
,      TAX_ORIGINAL
,      TAX_REMAINING
,      SELECTED_FOR_RECEIPT_BATCH_ID
,      RECEIVABLE_APPLICATION_ID
,      SECONDARY_APPLICATION_REF_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRX_BILLING_NUMBER
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      COMMENTS
,      TRANSACTION_CATEGORY
,      RECEIVABLES_TRX_ID
,      REC_ACTIVITY_NAME
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_TYPE_MEANING
,      APPLICATION_REF_ID
,      APPLICATION_REF_NUM
,      PAYMENT_SET_ID
,      APPLICATION_REF_REASON
,      APPLICATION_REF_REASON_MEANING
,      CUSTOMER_REFERENCE
,      CUSTOMER_REASON
,      APPLIED_REC_APP_ID
,      SECONDARY_APPLICATION_REF_TYPE
,      SECONDARY_APPLICATION_REF_NUM
,      INCLUDE_IN_ACCUMULATION
,      ON_ACCT_CUST_ID
,      ON_ACCT_CUST_SITE_USE_ID
,      ON_ACCT_PO_NUM
FROM APPS.AR_RECEIVABLE_APPLICATIONS_V;

Dependencies

[top of page]

APPS

ARPT_SQL_FUNC_UTIL - show dependent code

ARP_DEDUCTION - show dependent code

AR_CASH_RECEIPTS

AR_CONS_INV

AR_LOOKUPS

AR_PAYMENT_SCHEDULES

AR_RECEIVABLES_TRX

AR_RECEIVABLE_APPLICATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES

HZ_PARTIES

RA_BATCH_SOURCES

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_LINES

RA_CUST_TRX_TYPES

APPS.AR_RECEIVABLE_APPLICATIONS_V is not referenced by any database object