[Home] [Help] [Dependency Information]

VIEW: APPS.AR_PAYMENT_SCHEDULES_TRX2_V

Object Details

Object Name:	AR_PAYMENT_SCHEDULES_TRX2_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_PAYMENT_SCHEDULES_TRX2_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
,      PAYMENT_SCHEDULE_ID
,      TRX_NUMBER
,      TRX_DATE
,      TERMS_SEQUENCE_NUMBER
,      INVOICE_CURRENCY_CODE
,      EXCHANGE_RATE
,      GL_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      CUST_TRX_TYPE_ID
,      CASH_RECEIPT_ID
,      CLASS
,      STATUS
,      STATE_DSP
,      STATE
,      RECEIPT_CONFIRMED_FLAG
,      SELECTED_FOR_RECEIPT_BATCH_ID
,      COLLECTOR_LAST
,      FOLLOW_UP_CODE_LAST
,      IN_COLLECTION
,      TERM_ID
,      RAC_CUSTOMER_NAME
,      RAC_CUSTOMER_NUMBER
,      SU_LOCATION
,      BS_BATCH_SOURCE_NAME
,      TYPE_NAME
,      AL_CLASS_MEANING
,      DOC_SEQUENCE_VALUE
,      CT_PURCHASE_ORDER
,      CT_PREVIOUS_CUSTOMER_TRX_ID
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      DUE_DAYS
,      DUE_DATE
,      AMOUNT_DUE_ORIGINAL
,      ACCTD_AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_DUE_REMAINING
,      AL_STATUS_MEANING
,      ACTUAL_DATE_CLOSED
,      GL_DATE_CLOSED
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      ACCTD_AMOUNT_LINE_ITEMS_ORIG
,      AMOUNT_LINE_ITEMS_REMAINING
,      ACCTD_AMOUNT_LINE_ITEMS_REMAIN
,      TAX_ORIGINAL
,      ACCTD_TAX_ORIGINAL
,      TAX_REMAINING
,      ACCTD_TAX_REMAINING
,      FREIGHT_ORIGINAL
,      ACCTD_FREIGHT_ORIGINAL
,      FREIGHT_REMAINING
,      ACCTD_FREIGHT_REMAINING
,      AMOUNT_ADJUSTED
,      ACCTD_AMOUNT_ADJUSTED
,      AMOUNT_ADJUSTED_PENDING
,      ACCTD_AMOUNT_ADJUSTED_PENDING
,      RECEIVABLES_CHARGES_CHARGED
,      ACCTD_REC_CHARGES_CHARGED
,      RECEIVABLES_CHARGES_REMAINING
,      ACCTD_REC_CHARGES_REMAINING
,      AMOUNT_APPLIED
,      ACCTD_AMOUNT_APPLIED
,      AMOUNT_CREDITED
,      ACCTD_AMOUNT_CREDITED
,      AMOUNT_IN_DISPUTE
,      ACCTD_AMOUNT_IN_DISPUTE
,      DISPUTE_DATE
,      DISCOUNT_TAKEN_EARNED
,      ACCTD_DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
,      ACCTD_DISCOUNT_TAKEN_UNEARNED
,      AL_SELECTED_FOR_RECEIPT_FLAG
,      AL_SELECTED_FOR_RECEIPT_CODE
,      AL_RECEIPT_CONFIRMED_MEANING
,      CR_SELECTED_RECEIPT_NUMBER
,      ARB_SELECTED_BATCH_NAME
,      ARB_SELECTED_BATCH_DATE
,      DAYS_PAST_DUE
,      DUNNING_DATE_LAST
,      CALL_DATE_LAST
,      PROMISE_AMOUNT_LAST
,      ACCTD_PROMISE_AMOUNT_LAST
,      PROMISE_DATE_LAST
,      AL_FOLLOW_UP_LAST_MEANING
,      FOLLOW_UP_DATE_LAST
,      AL_IN_COLLECTION_MEANING
,      RAT_TERM_NAME
,      CHARGEBACK_INVOICE_NUM
,      CHARGEBACK_BATCH_SOURCE
,      BILLING_NUMBER
,      STAGED_DUNNING_LEVEL
,      DUNNING_LEVEL_OVERRIDE_DATE
,      REMITTANCE_METHOD
,      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
,      CONS_INV_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      COMMENTS
,      LEGAL_ENTITY_ID
,      BILLING_DATE
,      ORG_ID
FROM APPS.AR_PAYMENT_SCHEDULES_TRX2_V;

Dependencies

[top of page]

APPS

ARPT_SQL_FUNC_UTIL - show dependent code

ARP_VIEW_CONSTANTS - show dependent code

AR_CONS_INV_ALL

AR_PAYMENT_SCHEDULES

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES_ALL

HZ_PARTIES

RA_BATCH_SOURCES_ALL

RA_CUSTOMER_TRX_ALL

RA_CUST_TRX_TYPES_ALL

APPS.AR_PAYMENT_SCHEDULES_TRX2_V is not referenced by any database object