JL_BR_AR_PAYMENT_SCH_IOB

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID PAYMENT_SCHEDULE_ID DUE_DATE AMOUNT_DUE_REMAINING CUSTOMER_ID CUSTOMER_TRX_ID TRX_NUMBER GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 CUSTOMER_NAME ORG_ID TRADE_NOTE_NUMBER

Name

ROW_ID

PAYMENT_SCHEDULE_ID

DUE_DATE

AMOUNT_DUE_REMAINING

CUSTOMER_ID

CUSTOMER_TRX_ID

TRX_NUMBER

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

CUSTOMER_NAME

ORG_ID

TRADE_NOTE_NUMBER

Query

SQL_Statement
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

SQL_Statement

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