Product: | AR - Receivables |
---|---|
Description: | -Retrofitted |
Implementation/DBA Data: | APPS.ARBV_AR_PAYMENT_SCHEDULES |
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