VIEW: APPS.ARBV_AR_PAYMENT_SCHEDULES

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ PS.PAYMENT_SCHEDULE_ID , /* REGULAR ATTRIBUTES */ PS.DUE_DATE , '_LA:PS.CLASS:AR_LOOKUPS:INV/CM:MEANING' , '_LA:PS.STATUS:AR_LOOKUPS:PAYMENT_SCHEDULE_STATUS:MEANING' , PS.DISCOUNT_TAKEN_EARNED , PS.DISCOUNT_TAKEN_UNEARNED , PS.GL_DATE , PS.AMOUNT_DUE_ORIGINAL , PS.AMOUNT_DUE_REMAINING , PS.ACCTD_AMOUNT_DUE_REMAINING , PS.AMOUNT_LINE_ITEMS_ORIGINAL , PS.AMOUNT_LINE_ITEMS_REMAINING , PS.FREIGHT_ORIGINAL , PS.FREIGHT_REMAINING , PS.TAX_ORIGINAL , PS.TAX_REMAINING , PS.AMOUNT_CREDITED , PS.RECEIVABLES_CHARGES_CHARGED , PS.RECEIVABLES_CHARGES_REMAINING , PS.EXCHANGE_RATE , PS.EXCHANGE_RATE_TYPE , PS.EXCHANGE_DATE , PS.NUMBER_OF_DUE_DATES , PS.TERMS_SEQUENCE_NUMBER , PS.AMOUNT_IN_DISPUTE , PS.DISPUTE_DATE , PS.GL_DATE_CLOSED , PS.ACTUAL_DATE_CLOSED , '_LA:PS.IN_COLLECTION:AR_LOOKUPS:YES/NO:MEANING' , PS.CALL_DATE_LAST , '_LA:PS.FOLLOW_UP_CODE_LAST:AR_LOOKUPS:FOLLOW_UP:MEANING' , PS.FOLLOW_UP_DATE_LAST , PS.PROMISE_DATE_LAST , PS.PROMISE_AMOUNT_LAST , '_LA:PS.EXCLUDE_FROM_DUNNING_FLAG:AR_LOOKUPS:YES/NO:MEANING' , PS.STAGED_DUNNING_LEVEL , PS.DUNNING_LEVEL_OVERRIDE_DATE , CI.CONS_BILLING_NUMBER , /* IDS */ PS.COLLECTOR_LAST , PS.INVOICE_CURRENCY_CODE , PS.CUSTOMER_TRX_ID , PS.CASH_RECEIPT_ID , PS.CUSTOMER_ID , PS.TERM_ID , PS.ORG_ID , /* WHO COLUMNS */ PS.LAST_UPDATE_DATE , PS.LAST_UPDATED_BY , PS.CREATION_DATE , PS.CREATED_BY, PS.CUSTOMER_SITE_USE_ID, PS.CLASS FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CI WHERE PS.CONS_INV_ID = CI.CONS_INV_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ PS.PAYMENT_SCHEDULE_ID
, /* REGULAR ATTRIBUTES */ PS.DUE_DATE
, '_LA:PS.CLASS:AR_LOOKUPS:INV/CM:MEANING'
, '_LA:PS.STATUS:AR_LOOKUPS:PAYMENT_SCHEDULE_STATUS:MEANING'
, PS.DISCOUNT_TAKEN_EARNED
, PS.DISCOUNT_TAKEN_UNEARNED
, PS.GL_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.ACCTD_AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.AMOUNT_LINE_ITEMS_REMAINING
, PS.FREIGHT_ORIGINAL
, PS.FREIGHT_REMAINING
, PS.TAX_ORIGINAL
, PS.TAX_REMAINING
, PS.AMOUNT_CREDITED
, PS.RECEIVABLES_CHARGES_CHARGED
, PS.RECEIVABLES_CHARGES_REMAINING
, PS.EXCHANGE_RATE
, PS.EXCHANGE_RATE_TYPE
, PS.EXCHANGE_DATE
, PS.NUMBER_OF_DUE_DATES
, PS.TERMS_SEQUENCE_NUMBER
, PS.AMOUNT_IN_DISPUTE
, PS.DISPUTE_DATE
, PS.GL_DATE_CLOSED
, PS.ACTUAL_DATE_CLOSED
, '_LA:PS.IN_COLLECTION:AR_LOOKUPS:YES/NO:MEANING'
, PS.CALL_DATE_LAST
, '_LA:PS.FOLLOW_UP_CODE_LAST:AR_LOOKUPS:FOLLOW_UP:MEANING'
, PS.FOLLOW_UP_DATE_LAST
, PS.PROMISE_DATE_LAST
, PS.PROMISE_AMOUNT_LAST
, '_LA:PS.EXCLUDE_FROM_DUNNING_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, PS.STAGED_DUNNING_LEVEL
, PS.DUNNING_LEVEL_OVERRIDE_DATE
, CI.CONS_BILLING_NUMBER
, /* IDS */ PS.COLLECTOR_LAST
, PS.INVOICE_CURRENCY_CODE
, PS.CUSTOMER_TRX_ID
, PS.CASH_RECEIPT_ID
, PS.CUSTOMER_ID
, PS.TERM_ID
, PS.ORG_ID
, /* WHO COLUMNS */ PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PS.CREATION_DATE
, PS.CREATED_BY
, PS.CUSTOMER_SITE_USE_ID
, PS.CLASS
FROM AR_PAYMENT_SCHEDULES PS
, AR_CONS_INV CI
WHERE PS.CONS_INV_ID = CI.CONS_INV_ID (+) WITH READ ONLY