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 517: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,

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