APPS.AR_INVOICE_SQL_FUNC_PUB dependencies on RA_CUSTOMER_TRX

Line 45: from ra_customer_trx_lines

41: BEGIN
42:
43: select translated_description
44: into l_description
45: from ra_customer_trx_lines
46: where customer_trx_line_id = p_customer_trx_line_id;
47:
48: return(l_description);
49:

Line 179: FROM ra_customer_trx trx,

175: +-------------------------------------------*/
176:
177: SELECT NVL(SUM(adj.amount),0)
178: INTO commit_adjustments
179: FROM ra_customer_trx trx,
180: ra_cust_trx_types type,
181: ar_adjustments adj
182: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
183: AND type.type in ('INV', 'CM')

Line 196: FROM ra_customer_trx trx,

192: AND adj.adjustment_type = 'C';
193:
194: SELECT NVL(SUM(line.extended_amount),0)
195: INTO commit_total_activity
196: FROM ra_customer_trx trx,
197: ra_cust_trx_types type,
198: ra_customer_trx_lines line
199: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
200: AND trx.customer_trx_id = line.customer_trx_id

Line 198: ra_customer_trx_lines line

194: SELECT NVL(SUM(line.extended_amount),0)
195: INTO commit_total_activity
196: FROM ra_customer_trx trx,
197: ra_cust_trx_types type,
198: ra_customer_trx_lines line
199: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
200: AND trx.customer_trx_id = line.customer_trx_id
201: AND type.type = 'CM'
202: AND trx.complete_flag = 'Y'

Line 351: FROM ra_customer_trx trx,

347: +-------------------------------------------*/
348:
349: SELECT NVL(SUM(adj.amount),0)
350: INTO commit_adjustments
351: FROM ra_customer_trx trx,
352: ra_cust_trx_types type,
353: ar_adjustments adj
354: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
355: AND type.type in ('INV', 'CM')

Line 368: FROM ra_customer_trx trx,

364: AND adj.adjustment_type = 'C';
365:
366: SELECT NVL(SUM(line.extended_amount),0)
367: INTO commit_total_activity
368: FROM ra_customer_trx trx,
369: ra_cust_trx_types type,
370: ra_customer_trx_lines line
371: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
372: AND trx.customer_trx_id = line.customer_trx_id

Line 370: ra_customer_trx_lines line

366: SELECT NVL(SUM(line.extended_amount),0)
367: INTO commit_total_activity
368: FROM ra_customer_trx trx,
369: ra_cust_trx_types type,
370: ra_customer_trx_lines line
371: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
372: AND trx.customer_trx_id = line.customer_trx_id
373: AND type.type = 'CM'
374: AND trx.complete_flag = 'Y'

Line 415: || DESCRIPTION This procedure updates the ra_customer_trx table

411:
412: /*=============================================================================
413: || PRIVATE PROCEDURE update_customer_trx
414: ||
415: || DESCRIPTION This procedure updates the ra_customer_trx table
416: || and sets the printing information.
417: ||
418: || ARGUMENTS
419: || IN: p_choice

Line 463: UPDATE ra_customer_trx

459: null,
460: 'PRINT');
461: END IF;
462:
463: UPDATE ra_customer_trx
464: SET printing_pending =
465: decode (p_trx_type, 'CM', 'N',
466: decode (p_term_count,
467: greatest(nvl(last_printed_sequence_num,0),

Line 514: FROM ra_customer_trx_lines l

510:
511: CURSOR sel_taxyn( line_id in number ) IS
512: SELECT 'x' from dual where exists
513: ( SELECT 'x'
514: FROM ra_customer_trx_lines l
515: WHERE l.link_to_cust_trx_line_id = line_id
516: AND l.line_type = 'TAX'
517: AND l.extended_amount <> 0 );
518:

Line 724: /* ra_customer_trx.remit_to_address_id is not populated

720: (p_previous_customer_trx_id IS NOT NULL)
721: )
722:
723: THEN
724: /* ra_customer_trx.remit_to_address_id is not populated
725: for CM, need to get it from the invoice. */
726:
727: SELECT remit_to_address_id
728: INTO l_remit_to_address_id

Line 729: FROM ra_customer_trx

725: for CM, need to get it from the invoice. */
726:
727: SELECT remit_to_address_id
728: INTO l_remit_to_address_id
729: FROM ra_customer_trx
730: WHERE customer_trx_id = p_previous_customer_trx_id;
731:
732: END IF;
733: