DBA Data[Home] [Help]

APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on RA_TERMS_LINES_DISCOUNTS

Line 302: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,

298: decode(CURSOR_PS.BANK_CHARGE_AMOUNT,'','',0,'',CURSOR_PS.BANK_CHARGES_CCID),
299: CURSOR_PS.BANK_CHARGE_AMOUNT,
300: CURSOR_PS.BANK_CHARGE_AMOUNT,
301: CURSOR_PS.org_id
302: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,
303: AR_PAYMENT_SCHEDULES_ALL PS
304: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
305: and T.TERM_ID(+) = PS.TERM_ID
306: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER

Line 513: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,

509: decode(CURSOR_PS.FACTORING_AMOUNT,'','',0,'',CURSOR_PS.FACTORING_INTEREST_CCID),
510: CURSOR_PS.FACTORING_AMOUNT,
511: CURSOR_PS.FACTORING_AMOUNT,
512: CURSOR_PS.ORG_ID
513: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,
514: AR_PAYMENT_SCHEDULES PS
515: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
516: and T.TERM_ID(+) = PS.TERM_ID
517: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER