APPS.ECE_CDMO_UTIL dependencies on RA_CUSTOMER_TRX

Line 47: ra_customer_trx rct,

43: SELECT etd.edi_flag,etd.print_flag
44: INTO l_EDI_flag,
45: l_Print_flag
46: FROM
47: ra_customer_trx rct,
48: hz_cust_site_uses_all csu,
49: hz_cust_acct_sites_all cas,
50: ece_tp_headers eth,
51: ece_tp_details etd

Line 95: UPDATE ra_customer_trx

91:
92: ec_debug.pl ( 3, 'L_UPDATE_VALUE: ',l_Update_Value );
93:
94: xProgress := '2010-20';
95: UPDATE ra_customer_trx
96: SET last_update_date = SYSDATE,
97: printing_pending = DECODE (Document_Type,
98: 'CM', 'N',
99: 'OACM', 'N',

Line 128: 'RA_CUSTOMER_TRX' );

124: xProgress,
125: 'INFO',
126: 'EDI PROCESSED',
127: 'TABLE_NAME',
128: 'RA_CUSTOMER_TRX' );
129: END IF;
130:
131: /* The following lines were commented out was because of a request
132: from a beta site. Their business practice requires them to

Line 193: FROM RA_CUSTOMER_TRX

189: ec_debug.pl(3, 'Inside Get Remit to Address');
190: xProgress := '2000-30';
191: begin
192: SELECT REMIT_TO_ADDRESS_ID INTO l_remit_to_address_id
193: FROM RA_CUSTOMER_TRX
194: WHERE CUSTOMER_TRX_ID = get_remit_address.customer_trx_id;
195: exception
196: when no_data_found
197: then

Line 208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,

204: DECLARE
205: -- bug 4718847
206: CURSOR remit_cur IS
207: SELECT RT.ADDRESS_ID
208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,
209: HZ_PARTY_SITES HPS,HZ_LOCATIONS LOC
210: WHERE RCT.CUSTOMER_TRX_ID = get_remit_address.customer_trx_id
211: AND RCT.BILL_TO_ADDRESS_ID = A.CUST_ACCT_SITE_ID
212: AND A.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 345: FROM RA_CUSTOMER_TRX RCT, RA_CUST_TRX_TYPES RCTT, RA_TERMS_LINES RTL,

341: MIN(RTL.SEQUENCE_NUM)
342: INTO l_term_id, l_currency_precision, l_payment_schedule_exists, l_type,
343: l_first_installment_code, multiple_installments_flag,
344: maximum_installment_number, l_minimum_installment_number
345: FROM RA_CUSTOMER_TRX RCT, RA_CUST_TRX_TYPES RCTT, RA_TERMS_LINES RTL,
346: RA_TERMS RT, FND_CURRENCIES FC
347: WHERE RCT.CUSTOMER_TRX_ID = get_payment.customer_trx_id
348: AND RCT.INVOICE_CURRENCY_CODE = FC.CURRENCY_CODE
349: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID

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;