eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX

Line 338: FROM ra_customer_trx

334: the Debit Memo transaction */
335:
336: SELECT nvl(max(instr(trx_number,'-NDJ')) + 4,0) --bug 6011423
337: INTO X_first_position
338: FROM ra_customer_trx
339: WHERE related_customer_trx_id=X_original_customer_trx_id
340: AND trx_number like '%-NDJ%';
341:
342: SELECT nvl(MAX(TO_NUMBER(SUBSTR(trx_number,X_first_position,LENGTH(trx_number)-

Line 345: FROM ra_customer_trx

341:
342: SELECT nvl(MAX(TO_NUMBER(SUBSTR(trx_number,X_first_position,LENGTH(trx_number)-
343: X_first_position+1)))+1,1) --bug 6011423
344: INTO X_next_sequence
345: FROM ra_customer_trx
346: WHERE related_customer_trx_id=X_original_customer_trx_id
347: AND trx_number LIKE '%-NDJ%';
348:
349: /* If the selects failure, then this is the first

Line 370: /* Procedure ins_ra_customer_trx */

366: RETURN X_trx_number;
367: END generate_interest_DM_number;
368:
369: /************************************************************************/
370: /* Procedure ins_ra_customer_trx */
371: /* Purpose : Get the fields to insert into ra_customer_trx */
372: /************************************************************************/
373:
374: PROCEDURE ins_ra_customer_trx (

Line 371: /* Purpose : Get the fields to insert into ra_customer_trx */

367: END generate_interest_DM_number;
368:
369: /************************************************************************/
370: /* Procedure ins_ra_customer_trx */
371: /* Purpose : Get the fields to insert into ra_customer_trx */
372: /************************************************************************/
373:
374: PROCEDURE ins_ra_customer_trx (
375: X_inv_cust_trx_id IN NUMBER,

Line 374: PROCEDURE ins_ra_customer_trx (

370: /* Procedure ins_ra_customer_trx */
371: /* Purpose : Get the fields to insert into ra_customer_trx */
372: /************************************************************************/
373:
374: PROCEDURE ins_ra_customer_trx (
375: X_inv_cust_trx_id IN NUMBER,
376: X_new_cust_trx_id IN OUT NOCOPY NUMBER,
377: X_set_of_books_id IN OUT NOCOPY NUMBER,
378: X_lastlogin IN OUT NOCOPY NUMBER,

Line 410: l_trx_rec ra_customer_trx%ROWTYPE;

406: X_global_attribute6 VARCHAR2(150);
407: X_global_attribute7 VARCHAR2(150);
408: X_org_id NUMBER(15);
409:
410: l_trx_rec ra_customer_trx%ROWTYPE;
411:
412:
413: BEGIN
414: /* SELECT ra_customer_trx_s.nextval

Line 414: /* SELECT ra_customer_trx_s.nextval

410: l_trx_rec ra_customer_trx%ROWTYPE;
411:
412:
413: BEGIN
414: /* SELECT ra_customer_trx_s.nextval
415: INTO X_new_cust_trx_id
416: FROM sys.dual;
417: */
418:

Line 470: FROM ra_customer_trx

466: X_global_attribute5,
467: X_global_attribute6,
468: X_global_attribute7,
469: X_org_id
470: FROM ra_customer_trx
471: WHERE customer_trx_id = X_inv_cust_trx_id;
472:
473: /* INSERT INTO ra_customer_trx (
474: customer_trx_id,

Line 473: /* INSERT INTO ra_customer_trx (

469: X_org_id
470: FROM ra_customer_trx
471: WHERE customer_trx_id = X_inv_cust_trx_id;
472:
473: /* INSERT INTO ra_customer_trx (
474: customer_trx_id,
475: last_update_date,
476: last_updated_by,
477: creation_date,

Line 602: END ins_ra_customer_trx;

598: EXCEPTION
599: WHEN NO_DATA_FOUND THEN
600: RAISE_APPLICATION_ERROR( -20000,
601: 'IL: Id da Transacao Invalido'||sqlerrm );
602: END ins_ra_customer_trx;
603:
604: /************************************************************************/
605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */

Line 605: /* Procedure ins_ra_customer_trx_lines */

601: 'IL: Id da Transacao Invalido'||sqlerrm );
602: END ins_ra_customer_trx;
603:
604: /************************************************************************/
605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (

Line 606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */

602: END ins_ra_customer_trx;
603:
604: /************************************************************************/
605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (
610: X_new_customer_trx_id IN NUMBER,

Line 609: PROCEDURE ins_ra_customer_trx_lines (

605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (
610: X_new_customer_trx_id IN NUMBER,
611: X_invoice_amount IN NUMBER,
612: X_set_of_books_id IN NUMBER,
613: X_user_id IN NUMBER,

Line 619: SELECT ra_customer_trx_lines_s.nextval

615: X_customertrx_line_id IN OUT NOCOPY NUMBER
616: ) IS
617: l_org_id NUMBER(15);
618: BEGIN
619: SELECT ra_customer_trx_lines_s.nextval
620: INTO X_customertrx_line_id
621: FROM dual;
622:
623: SELECT org_id into l_org_id

Line 624: FROM ra_customer_trx_all

620: INTO X_customertrx_line_id
621: FROM dual;
622:
623: SELECT org_id into l_org_id
624: FROM ra_customer_trx_all
625: Where customer_trx_id = x_new_customer_trx_id;
626:
627: INSERT INTO ra_customer_trx_lines (
628: customer_trx_line_id,

Line 627: INSERT INTO ra_customer_trx_lines (

623: SELECT org_id into l_org_id
624: FROM ra_customer_trx_all
625: Where customer_trx_id = x_new_customer_trx_id;
626:
627: INSERT INTO ra_customer_trx_lines (
628: customer_trx_line_id,
629: last_update_date,
630: last_updated_by,
631: creation_date,

Line 664: END ins_ra_customer_trx_lines;

660: X_invoice_amount,
661: 'S',
662: l_org_id
663: );
664: END ins_ra_customer_trx_lines;
665:
666: /***************************************************************************/
667: /* Procedure ins_ra_cust_trx_line_salesreps */
668: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */

Line 681: FROM ra_customer_trx_all where

677: ) IS
678: l_org_id NUMBER(15);
679: BEGIN
680: SELECT org_id into l_org_id
681: FROM ra_customer_trx_all where
682: customer_trx_id = x_new_cust_trx_id;
683:
684: INSERT INTO ra_cust_trx_line_salesreps (
685: cust_trx_line_salesrep_id,

Line 779: SELECT org_id into l_org_id from ra_customer_trx_all where

775: l_org_id NUMBER(15);
776:
777: BEGIN
778:
779: SELECT org_id into l_org_id from ra_customer_trx_all where
780: customer_trx_id = x_customer_trx_id;
781: SELECT chart_of_accounts_id into x_struct_num FROM gl_sets_of_books
782: WHERE set_of_books_id = x_set_of_books_id;
783:

Line 994: ra_customer_trx_all

990:
991: /* Replace Insert by AR's table handler. Bug # 2249731 */
992:
993: SELECT org_id into l_org_id from
994: ra_customer_trx_all
995: where customer_trx_id = X_customer_trx_id;
996: l_ps_rec.last_update_date := sysdate;
997: l_ps_rec.last_updated_by := X_user_id;
998: l_ps_rec.creation_date := sysdate;

Line 1093: FROM ra_customer_trx, fnd_currencies_vl

1089: -- currency code.
1090: -----------------------------------------------------
1091: SELECT invoice_currency_code, minimum_accountable_unit, precision
1092: INTO X_invoice_currency_code, x_minimum_accountable_unit, x_precision
1093: FROM ra_customer_trx, fnd_currencies_vl
1094: WHERE customer_trx_id = X_original_customer_trx_id
1095: AND invoice_currency_code = currency_code;
1096:
1097: jl_br_ar_generate_debit_memo.ins_ra_batches ( X_batch_source_id,

Line 1104: jl_br_ar_generate_debit_memo.ins_ra_customer_trx (

1100: X_user_id,
1101: X_batch_id );
1102:
1103:
1104: jl_br_ar_generate_debit_memo.ins_ra_customer_trx (
1105: X_original_customer_trx_id,
1106: X_new_customer_trx_id,
1107: X_set_of_books_id,
1108: X_last_login,

Line 1125: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (

1121: X_batch_id,
1122: X_interest_DM_date
1123: );
1124:
1125: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (
1126: X_new_customer_trx_id,
1127: X_invoice_amount,
1128: X_set_of_books_id,
1129: X_user_id,