DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AR_PAYMENT_SCHEDULES_V

Object Details
Object Name: AR_PAYMENT_SCHEDULES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_PAYMENT_SCHEDULES_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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PAYMENT_SCHEDULE_ID NUMBER (15)
TRX_NUMBER VARCHAR2 (30)
TRX_DATE DATE

TERMS_SEQUENCE_NUMBER NUMBER (15)
INVOICE_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE NUMBER

GL_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CUSTOMER_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15)
CUST_TRX_TYPE_ID NUMBER (15)
CASH_RECEIPT_ID NUMBER (15)
CLASS VARCHAR2 (20)
STATUS VARCHAR2 (30)
STATE_DSP VARCHAR2 (4000)
STATE VARCHAR2 (30)
RECEIPT_CONFIRMED_FLAG VARCHAR2 (1)
SELECTED_FOR_RECEIPT_BATCH_ID NUMBER (15)
COLLECTOR_LAST NUMBER (15)
FOLLOW_UP_CODE_LAST VARCHAR2 (30)
IN_COLLECTION VARCHAR2 (0)
TERM_ID NUMBER (15)
RAC_CUSTOMER_NAME VARCHAR2 (360)
RAC_CUSTOMER_NUMBER VARCHAR2 (30)
SU_LOCATION VARCHAR2 (40)
BS_BATCH_SOURCE_NAME VARCHAR2 (50)
TYPE_NAME VARCHAR2 (30)
AL_CLASS_MEANING VARCHAR2 (4000)
DOC_SEQUENCE_VALUE NUMBER (15)
CT_PURCHASE_ORDER VARCHAR2 (50)
CT_PREVIOUS_CUSTOMER_TRX_ID NUMBER

INTERFACE_HEADER_CONTEXT VARCHAR2 (30)
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2 (150)
DUE_DAYS NUMBER

DUE_DATE DATE

AMOUNT_DUE_ORIGINAL NUMBER

ACCTD_AMOUNT_DUE_ORIGINAL VARCHAR2 (0)
AMOUNT_DUE_REMAINING NUMBER

ACCTD_AMOUNT_DUE_REMAINING NUMBER

AL_STATUS_MEANING VARCHAR2 (4000)
ACTUAL_DATE_CLOSED DATE

GL_DATE_CLOSED DATE

AMOUNT_LINE_ITEMS_ORIGINAL NUMBER

ACCTD_AMOUNT_LINE_ITEMS_ORIG NUMBER

AMOUNT_LINE_ITEMS_REMAINING NUMBER

ACCTD_AMOUNT_LINE_ITEMS_REMAIN NUMBER

TAX_ORIGINAL NUMBER

ACCTD_TAX_ORIGINAL NUMBER

TAX_REMAINING NUMBER

ACCTD_TAX_REMAINING NUMBER

FREIGHT_ORIGINAL NUMBER

ACCTD_FREIGHT_ORIGINAL NUMBER

FREIGHT_REMAINING NUMBER

ACCTD_FREIGHT_REMAINING NUMBER

AMOUNT_ADJUSTED NUMBER

ACCTD_AMOUNT_ADJUSTED NUMBER

AMOUNT_ADJUSTED_PENDING NUMBER

ACCTD_AMOUNT_ADJUSTED_PENDING NUMBER

RECEIVABLES_CHARGES_CHARGED NUMBER

ACCTD_REC_CHARGES_CHARGED NUMBER

RECEIVABLES_CHARGES_REMAINING NUMBER

ACCTD_REC_CHARGES_REMAINING NUMBER

AMOUNT_APPLIED NUMBER

ACCTD_AMOUNT_APPLIED NUMBER

AMOUNT_CREDITED NUMBER

ACCTD_AMOUNT_CREDITED NUMBER

AMOUNT_IN_DISPUTE NUMBER

ACCTD_AMOUNT_IN_DISPUTE NUMBER

DISPUTE_DATE DATE

DISCOUNT_TAKEN_EARNED NUMBER

ACCTD_DISCOUNT_TAKEN_EARNED NUMBER

DISCOUNT_TAKEN_UNEARNED NUMBER

ACCTD_DISCOUNT_TAKEN_UNEARNED NUMBER

AL_SELECTED_FOR_RECEIPT_FLAG VARCHAR2 (4000)
AL_SELECTED_FOR_RECEIPT_CODE VARCHAR2 (1)
AL_RECEIPT_CONFIRMED_MEANING VARCHAR2 (4000)
CR_SELECTED_RECEIPT_NUMBER VARCHAR2 (0)
ARB_SELECTED_BATCH_NAME VARCHAR2 (0)
ARB_SELECTED_BATCH_DATE VARCHAR2 (0)
DAYS_PAST_DUE NUMBER

DUNNING_DATE_LAST VARCHAR2 (9)
CALL_DATE_LAST DATE

PROMISE_AMOUNT_LAST NUMBER

ACCTD_PROMISE_AMOUNT_LAST NUMBER

PROMISE_DATE_LAST DATE

AL_FOLLOW_UP_LAST_MEANING VARCHAR2 (4000)
FOLLOW_UP_DATE_LAST DATE

AL_IN_COLLECTION_MEANING VARCHAR2 (0)
RAT_TERM_NAME VARCHAR2 (4000)
CHARGEBACK_INVOICE_NUM VARCHAR2 (30)
CHARGEBACK_BATCH_SOURCE VARCHAR2 (50)
BILLING_NUMBER VARCHAR2 (30)
STAGED_DUNNING_LEVEL NUMBER (2)
DUNNING_LEVEL_OVERRIDE_DATE DATE

REMITTANCE_METHOD VARCHAR2 (30)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
CONS_INV_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

COMMENTS VARCHAR2 (2000)
LEGAL_ENTITY_ID NUMBER (15)
BILLING_DATE DATE

ORG_ID NUMBER (15)
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_V;

Dependencies

[top of page]

APPS.AR_PAYMENT_SCHEDULES_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
PL/SQL PackageARP_VIEW_CONSTANTS - show dependent code
SynonymAR_BATCHES_ALL
SynonymAR_BATCH_SOURCES_ALL
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_CASH_RECEIPT_HISTORY_ALL
SynonymAR_CONS_INV_ALL
ViewAR_LOOKUPS
SynonymAR_PAYMENT_SCHEDULES
SynonymAR_RECEIPT_CLASSES
SynonymAR_RECEIPT_METHODS
SynonymFND_CURRENCIES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymRA_BATCH_SOURCES_ALL
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUST_TRX_TYPES_ALL
APPS.AR_PAYMENT_SCHEDULES_V is referenced by following:

SchemaAPPS
ViewIGI_AR_PAYMENT_SCHEDULES_V