VIEW: APPS.ARFV_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 , /* 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 PS, AR_CONS_INV CI, AR_COLLECTORS COL, FND_CURRENCIES_VL CURR, RA_CUSTOMER_TRX CT, AR_CASH_RECEIPTS 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 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
, /* 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 PS
, AR_CONS_INV CI
, AR_COLLECTORS COL
, FND_CURRENCIES_VL CURR
, RA_CUSTOMER_TRX CT
, AR_CASH_RECEIPTS 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 WITH READ ONLY