VIEW: APPS.LNS_OPEN_RECEIVABLES_V

Source

View Text - Preformatted

SELECT pmt_sch.payment_schedule_id, pmt_sch.customer_trx_id, pmt_sch.trx_number, pmt_sch.amount_due_original, pmt_sch.amount_due_remaining, pmt_sch.due_date, pmt_sch.cust_trx_type_id, pmt_sch.class, pmt_sch.trx_date, pmt_sch.gl_date, pmt_sch.number_of_due_dates, pmt_sch.term_id, pmt_sch.terms_sequence_number, pmt_sch.creation_date, pmt_sch.created_by, pmt_sch.last_updated_by, pmt_sch.last_update_date, account.party_id, pmt_sch.invoice_currency_code, pmt_sch.org_id FROM AR_PAYMENT_SCHEDULES_ALL pmt_sch, HZ_CUST_ACCOUNTS account WHERE pmt_sch.class in ('INV','DM') and pmt_sch.status = 'OP' and pmt_sch.customer_id = account.cust_account_id and pmt_sch.amount_due_remaining > 0

View Text - HTML Formatted

SELECT PMT_SCH.PAYMENT_SCHEDULE_ID
, PMT_SCH.CUSTOMER_TRX_ID
, PMT_SCH.TRX_NUMBER
, PMT_SCH.AMOUNT_DUE_ORIGINAL
, PMT_SCH.AMOUNT_DUE_REMAINING
, PMT_SCH.DUE_DATE
, PMT_SCH.CUST_TRX_TYPE_ID
, PMT_SCH.CLASS
, PMT_SCH.TRX_DATE
, PMT_SCH.GL_DATE
, PMT_SCH.NUMBER_OF_DUE_DATES
, PMT_SCH.TERM_ID
, PMT_SCH.TERMS_SEQUENCE_NUMBER
, PMT_SCH.CREATION_DATE
, PMT_SCH.CREATED_BY
, PMT_SCH.LAST_UPDATED_BY
, PMT_SCH.LAST_UPDATE_DATE
, ACCOUNT.PARTY_ID
, PMT_SCH.INVOICE_CURRENCY_CODE
, PMT_SCH.ORG_ID
FROM AR_PAYMENT_SCHEDULES_ALL PMT_SCH
, HZ_CUST_ACCOUNTS ACCOUNT
WHERE PMT_SCH.CLASS IN ('INV'
, 'DM')
AND PMT_SCH.STATUS = 'OP'
AND PMT_SCH.CUSTOMER_ID = ACCOUNT.CUST_ACCOUNT_ID
AND PMT_SCH.AMOUNT_DUE_REMAINING > 0