APPS.ECE_CDMO_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 386: FROM RA_CUSTOMER_TRX_LINES RCTL

382: SELECT NVL(SUM((NVL(RCTL.QUANTITY_INVOICED, RCTL.QUANTITY_CREDITED) *
383: RCTL.UNIT_SELLING_PRICE)
384: * l_term_relative_amount / l_term_base_amount),0)
385: INTO amount_charges_due
386: FROM RA_CUSTOMER_TRX_LINES RCTL
387: WHERE RCTL.CUSTOMER_TRX_ID = get_payment.customer_trx_id
388: AND RCTL.LINE_TYPE = 'CHARGES';
389:
390: ELSE

Line 399: FROM RA_CUSTOMER_TRX_LINES

395: xProgress := '2040-40';
396: SELECT ROUND(SUM(EXTENDED_AMOUNT * l_term_relative_amount /
397: l_term_base_amount),l_currency_precision)
398: INTO l_amount_line_items_due
399: FROM RA_CUSTOMER_TRX_LINES
400: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
401: AND LINE_TYPE NOT IN ('TAX','FREIGHT','CHARGES');
402:
403: xProgress := '2050-40';

Line 407: FROM RA_CUSTOMER_TRX_LINES

403: xProgress := '2050-40';
404: SELECT ROUND(SUM(EXTENDED_AMOUNT * l_term_relative_amount /
405: l_term_base_amount),l_currency_precision)
406: INTO l_amount_charges_due
407: FROM RA_CUSTOMER_TRX_LINES
408: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
409: AND LINE_TYPE = 'CHARGES';
410:
411: -- Check to see if the tax/freight are prorated across installments

Line 422: FROM RA_CUSTOMER_TRX_LINES

418:
419: xProgress := '2080-40';
420: SELECT SUM(EXTENDED_AMOUNT)
421: INTO l_amount_tax_due
422: FROM RA_CUSTOMER_TRX_LINES
423: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
424: AND LINE_TYPE = 'TAX';
425:
426: xProgress := '2090-40';

Line 429: FROM RA_CUSTOMER_TRX_LINES

425:
426: xProgress := '2090-40';
427: SELECT SUM(EXTENDED_AMOUNT)
428: INTO l_amount_freight_due
429: FROM RA_CUSTOMER_TRX_LINES
430: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
431: AND LINE_TYPE = 'FREIGHT';
432:
433: ELSE

Line 444: FROM RA_CUSTOMER_TRX_LINES

440: xProgress := '2100-40';
441: SELECT ROUND(SUM(EXTENDED_AMOUNT * l_term_relative_amount /
442: l_term_base_amount),l_currency_precision)
443: INTO l_amount_tax_due
444: FROM RA_CUSTOMER_TRX_LINES
445: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
446: AND LINE_TYPE = 'TAX';
447:
448: xProgress := '2110-40';

Line 452: FROM RA_CUSTOMER_TRX_LINES

448: xProgress := '2110-40';
449: SELECT ROUND(SUM(EXTENDED_AMOUNT * l_term_relative_amount /
450: l_term_base_amount),l_currency_precision)
451: INTO l_amount_freight_due
452: FROM RA_CUSTOMER_TRX_LINES
453: WHERE CUSTOMER_TRX_ID = get_payment.customer_trx_id
454: AND LINE_TYPE = 'FREIGHT';
455:
456: END IF;