View: JL_BR_AR_PAYMENT_SCH_IOB_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_BR_AR_PAYMENT_SCH_IOB_V

View Text

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

Columns