[Home] [Help] [Dependency Information]

VIEW: APPS.AR_INTERIM_CASH_RECEIPTS_V

Object Details

Object Name:	AR_INTERIM_CASH_RECEIPTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_INTERIM_CASH_RECEIPTS_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
,      AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      NET_AMOUNT
,      CURRENCY_CODE
,      RECEIPT_METHOD_ID
,      REMITTANCE_BANK_ACCOUNT_ID
,      BATCH_ID
,      BATCH_NAME
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_TYPE_DSP
,      GL_DATE
,      GL_POSTED_DATE
,      ANTICIPATED_CLEARING_DATE
,      PAY_FROM_CUSTOMER
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_BANK_BRANCH_ID
,      CUSTOMER_BANK_NAME
,      CUSTOMER_BANK_ACCOUNT_NUM
,      RECEIPT_DATE
,      RECEIPT_NUMBER
,      SITE_USE_ID
,      SPECIAL_TYPE
,      USSGL_TRANSACTION_CODE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      BILLING_LOCATION
,      TRX_NUMBER
,      BILLING_NUMBER
,      RECEIPT_METHOD_NAME
,      BANK_NAME
,      REMITTANCE_BANK_BRANCH_ID
,      BANK_ACCOUNT_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RECEIPT_CREATION_STATUS_DSP
,      RECEIPT_CREATION_STATUS
,      AMOUNT_APPLIED
,      TRANS_TO_RECEIPT_RATE
,      INVOICE_CURRENCY_CODE
,      APPLICATION_NOTES
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_TYPE_MEANING
,      CUSTOMER_REASON
,      CUSTOMER_REFERENCE
,      OVERAPPLICATION_INDICATOR
FROM APPS.AR_INTERIM_CASH_RECEIPTS_V;

Dependencies

[top of page]

APPS

ARPT_SQL_FUNC_UTIL - show dependent code

ARP_DEDUCTION - show dependent code

AR_BATCHES

AR_CONS_INV

AR_INTERIM_CASH_RECEIPTS

AR_LOOKUPS

AR_PAYMENT_SCHEDULES

AR_RECEIPT_CLASSES

AR_RECEIPT_METHODS

CE_BANK_ACCOUNTS

CE_BANK_ACCT_USES

CE_BANK_BRANCHES_V

FND_ACCESS_CONTROL_UTIL - show dependent code

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

GL_DAILY_CONVERSION_TYPES

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES

HZ_PARTIES

IBY_EXT_BANK_ACCOUNTS_V

MO_GLOBAL - show dependent code

RA_CUSTOMER_TRX

XTR_USER_ACCESS - show dependent code

APPS.AR_INTERIM_CASH_RECEIPTS_V is not referenced by any database object