eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ARFV_AR_PAYMENT_SCHEDULES_OLD1

Product:	AR - Receivables
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

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
, /* RESOLVED FK RESOLUTIONS */ COL.NAME
, CURR.DESCRIPTION
, CT.TRX_NUMBER
, CR.RECEIPT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, TER.NAME
, AOU.NAME
, '_DF:AR:AR_PAYMENT_SCHEDULES:PS'
, /* 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
FROM AR_PAYMENT_SCHEDULES_ALL PS
, AR_CONS_INV_ALL CI
, AR_COLLECTORS COL
, FND_CURRENCIES_VL CURR
, RA_CUSTOMER_TRX_ALL CT
, AR_CASH_RECEIPTS_ALL CR
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, RA_TERMS TER
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE PS.CONS_INV_ID = CI.CONS_INV_ID (+)
AND PS.COLLECTOR_LAST = COL.COLLECTOR_ID (+)
AND PS.INVOICE_CURRENCY_CODE = CURR.CURRENCY_CODE
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)
AND PS.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID (+)
AND PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID (+)
AND PS.TERM_ID = TER.TERM_ID (+)
AND PS.ORG_ID = AOU.ORGANIZATION_ID (+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND '_SEC:PS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PAYMENT_SCHEDULE_ID
DUE_DATE
"_LA:CLASS"
"_LA:ITEM_STATUS"
EARNED_DISCOUNT_TAKEN
UNEARNED_DISCOUNT_TAKEN
GENERAL_LEDGER_DATE
ORIGINAL_AMOUNT_DUE
BALANCE_DUE
BALANCE_DUE_IN_FUNCTIONAL_CURR
ORIGINAL_LINE_AMOUNT
REMAINING_LINE_AMOUNT
ORIGINAL_FREIGHT
REMAINING_FREIGHT
ORIGINAL_TAX
REMAINING_TAX
AMOUNT_CREDITED
RECEIVABLE_CHARGES_CHARGED
RECEIVABLE_CHARGES_REMAINING
CURRENCY_EXCHANGE_RATE
CURRENCY_EXCHANGE_RATE_TYPE
CURRENCY_EXCHANGE_RATE_DATE
TOTAL_NUMBER_OF_INSTALLMENTS
INSTALLMENT_SEQUENCE_NUMBER
DISPUTE_AMOUNT
DISPUTE_DATE
SCHEDULE_CLOSED_DATE
ACTUAL_DATE_CLOSED
"_LA:IN_COLLECTION_FLAG"
LAST_CALL_DATE
"_LA:LAST_FOLLOW_UP_OUTCOME"
LAST_FOLLOW_UP_DATE
LAST_PROMISE_DUE_DATE
LAST_PROMISE_AMOUNT
"_LA:EXCLUDE_DUNNING_FLAG"
STAGED_DUNNING_LEVEL
DUNNING_LEVEL_OVERRIDE_DATE
CONSOLIDATED_BILLING_NUMBER
LAST_COLLECTOR_CALLED
CURRENCY_DESCRIPTION
TRANSACTION_NUMBER
RECEIPT_NUMBER
CUSTOMER_NAME
PAYMENT_TERM_NAME
OPERATING_UNIT
_DF
COLLECTOR_LAST
INVOICE_CURRENCY_CODE
CUSTOMER_TRX_ID
CASH_RECEIPT_ID
CUSTOMER_ID
TERM_ID
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY