VIEW: APPS.JL_BR_AR_PAYMENT_SCH_IOB_V

Source

View Text - Preformatted

SELECT distinct SCH.ROWID ROW_ID , SCH.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , SCH.DUE_DATE DUE_DATE , SCH.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING , RCT.BILL_TO_CUSTOMER_ID CUSTOMER_ID , SCH.CUSTOMER_TRX_ID CUSTOMER_TRX_ID , RCT.TRX_NUMBER TRX_NUMBER , SCH.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10 , SCH.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11 , RAP.PARTY_NAME CUSTOMER_NAME , BOR.ORG_ID ORG_ID , SCH.TRX_NUMBER||'-'||TO_CHAR(SCH.TERMS_SEQUENCE_NUMBER) TRADE_NOTE_NUMBER FROM AR_PAYMENT_SCHEDULES_ALL SCH, JL_BR_AR_COLLECTION_DOCS_all COLL, JL_BR_AR_BORDEROS BOR, HZ_CUST_ACCOUNTS RAC, HZ_PARTIES RAP, RA_CUSTOMER_TRX_ALL RCT, CE_BANK_ACCT_USES_ALL ACCUSE WHERE sch.payment_schedule_id = coll.payment_schedule_id AND coll.bordero_id = bor.bordero_id AND bor.bordero_type IN('COLLECTION', 'FACTORING') AND rct.bill_to_customer_id = rac.cust_account_id AND rac.party_id = rap.party_id AND sch.customer_trx_id = rct.customer_trx_id AND sch.trx_number = rct.trx_number AND bor.bank_acct_use_id = coll.bank_acct_use_id AND coll.bank_acct_use_id = accuse.bank_acct_use_id AND coll.customer_trx_id = rct.customer_trx_id AND sch.org_id = bor.org_id AND bor.org_id = rct.org_id AND coll.org_id = bor.org_id AND accuse.org_id = bor.org_id

View Text - HTML Formatted

SELECT DISTINCT SCH.ROWID ROW_ID
, SCH.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, SCH.DUE_DATE DUE_DATE
, SCH.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, RCT.BILL_TO_CUSTOMER_ID CUSTOMER_ID
, SCH.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, RCT.TRX_NUMBER TRX_NUMBER
, SCH.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, SCH.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, RAP.PARTY_NAME CUSTOMER_NAME
, BOR.ORG_ID ORG_ID
, SCH.TRX_NUMBER||'-'||TO_CHAR(SCH.TERMS_SEQUENCE_NUMBER) TRADE_NOTE_NUMBER
FROM AR_PAYMENT_SCHEDULES_ALL SCH
, JL_BR_AR_COLLECTION_DOCS_ALL COLL
, JL_BR_AR_BORDEROS BOR
, HZ_CUST_ACCOUNTS RAC
, HZ_PARTIES RAP
, RA_CUSTOMER_TRX_ALL RCT
, CE_BANK_ACCT_USES_ALL ACCUSE
WHERE SCH.PAYMENT_SCHEDULE_ID = COLL.PAYMENT_SCHEDULE_ID
AND COLL.BORDERO_ID = BOR.BORDERO_ID
AND BOR.BORDERO_TYPE IN('COLLECTION'
, 'FACTORING')
AND RCT.BILL_TO_CUSTOMER_ID = RAC.CUST_ACCOUNT_ID
AND RAC.PARTY_ID = RAP.PARTY_ID
AND SCH.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND SCH.TRX_NUMBER = RCT.TRX_NUMBER
AND BOR.BANK_ACCT_USE_ID = COLL.BANK_ACCT_USE_ID
AND COLL.BANK_ACCT_USE_ID = ACCUSE.BANK_ACCT_USE_ID
AND COLL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND SCH.ORG_ID = BOR.ORG_ID
AND BOR.ORG_ID = RCT.ORG_ID
AND COLL.ORG_ID = BOR.ORG_ID
AND ACCUSE.ORG_ID = BOR.ORG_ID