[Home] [Help] [Dependency Information]

VIEW: APPS.AR_INTERIM_CR_LINES_V

Object Details

Object Name:	AR_INTERIM_CR_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_INTERIM_CR_LINES_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
,      CASH_RECEIPT_LINE_ID
,      PAYMENT_AMOUNT
,      DISCOUNT_TAKEN
,      DUE_DATE
,      BATCH_ID
,      BATCH_NAME
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      SOLD_TO_CUSTOMER
,      SOLD_CUSTOMER_NAME
,      SOLD_CUSTOMER_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      AMOUNT
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      GL_DATE
,      GL_POSTED_DATE
,      PAY_FROM_CUSTOMER
,      RECEIPT_DATE
,      RECEIPT_NUMBER
,      CURRENCY_CODE
,      RECEIPT_METHOD_ID
,      REMIT_BANK_ACCT_USE_ID
,      SITE_USE_ID
,      SPECIAL_TYPE
,      USSGL_TRANSACTION_CODE
,      CUSTOMER_BANK_ACCOUNT_ID
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      STATUS
,      PAY_CUSTOMER_NAME
,      PAY_CUSTOMER_NUMBER
,      BILLING_LOCATION
,      TRX_NUMBER
,      BILLING_NUMBER
,      TYPE_NAME
,      ALLOW_OVERAPPLICATION_FLAG
,      NATURAL_APPLICATION_ONLY_FLAG
,      CREATION_SIGN
,      RECEIPT_METHOD_NAME
,      BANK_NAME
,      REMITTANCE_BANK_BRANCH_ID
,      BANK_ACCOUNT_NUMBER
,      TERM_ID
,      TERMS_SEQUENCE_NUMBER
,      INVOICE_CURRENCY_CODE
,      AMOUNT_DUE_REMAINING
,      TRX_DATE
,      AMOUNT_DUE_ORIGINAL
,      DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      GRACE_DAYS
,      CALC_DISCOUNT_ON_LINES_FLAG
,      PARTIAL_DISCOUNT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_TYPE_MEANING
,      CUSTOMER_REASON
,      CUSTOMER_REFERENCE
,      APPLIED_REC_APP_ID
,      OVERAPPLICATION_INDICATOR
,      APPLICATION_STATUS
,      CLASS
,      CLASS_SHORT_NAME
,      APPLIED_CASH_RECEIPT_ID
FROM APPS.AR_INTERIM_CR_LINES_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_INTERIM_CASH_RECEIPT_LINES

AR_PAYMENT_SCHEDULES

AR_RECEIPT_METHODS

AR_RECEIVABLE_APPLICATIONS

CE_BANK_ACCOUNTS

CE_BANK_ACCT_USES

FND_ACCESS_CONTROL_UTIL - show dependent code

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

HZ_CUSTOMER_PROFILES

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES

HZ_PARTIES

HZ_RELATIONSHIPS

MO_GLOBAL - show dependent code

RA_CUSTOMER_TRX

RA_CUST_TRX_TYPES

RA_TERMS

XTR_USER_ACCESS - show dependent code

APPS.AR_INTERIM_CR_LINES_V is not referenced by any database object