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.JG_ZZ_AR_AUTO_INVOICE dependencies on RA_CUSTOMER_TRX_ALL

Line 49: From ra_customer_trx_all l

45: Procedure Trx_Num_Upd (p_request_id In Number) Is
46: Cursor C_Trx_Lines (x_request_id Number) Is
47: Select l.trx_number
48: ,l.customer_trx_id
49: From ra_customer_trx_all l
50: Where l.request_id = x_request_id
51: And l.complete_flag = 'Y'
52: And l.customer_trx_id Is Not Null;
53:

Line 60: From ra_customer_trx_all l

56: Select l.trx_number
57: ,l.customer_trx_id
58: ,global_attribute16
59: ,nvl(l.cust_trx_type_id,0)
60: From ra_customer_trx_all l
61: Where l.request_id = x_request_id
62: And l.complete_flag = 'Y'
63: And l.customer_trx_id Is Not Null;
64:

Line 97: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;

93: WHERE rbc_1.batch_source_id = p_batch_source_id
94: AND rbc_1.org_id = p_org_id;
95: -- End Bug 8709620
96:
97: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
98: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
99: TYPE gdf16 is Table of ra_customer_trx_all.global_attribute16%Type;
100: TYPE cust_trx_typ_id is Table of ra_customer_trx_all.cust_trx_type_id%Type;
101:

Line 98: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;

94: AND rbc_1.org_id = p_org_id;
95: -- End Bug 8709620
96:
97: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
98: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
99: TYPE gdf16 is Table of ra_customer_trx_all.global_attribute16%Type;
100: TYPE cust_trx_typ_id is Table of ra_customer_trx_all.cust_trx_type_id%Type;
101:
102: customer_trx_id trx_id;

Line 99: TYPE gdf16 is Table of ra_customer_trx_all.global_attribute16%Type;

95: -- End Bug 8709620
96:
97: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
98: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
99: TYPE gdf16 is Table of ra_customer_trx_all.global_attribute16%Type;
100: TYPE cust_trx_typ_id is Table of ra_customer_trx_all.cust_trx_type_id%Type;
101:
102: customer_trx_id trx_id;
103: trx_number trx_num;

Line 100: TYPE cust_trx_typ_id is Table of ra_customer_trx_all.cust_trx_type_id%Type;

96:
97: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
98: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
99: TYPE gdf16 is Table of ra_customer_trx_all.global_attribute16%Type;
100: TYPE cust_trx_typ_id is Table of ra_customer_trx_all.cust_trx_type_id%Type;
101:
102: customer_trx_id trx_id;
103: trx_number trx_num;
104: global_attribute16 gdf16;

Line 195: Update ra_customer_trx_all

191: End If;
192: End Loop;
193:
194: Forall j in customer_trx_id.FIRST .. customer_trx_id.LAST
195: Update ra_customer_trx_all
196: Set trx_number = trx_number(j)
197: Where customer_trx_id = customer_trx_id(j)
198: and request_id = p_request_id;
199: End If;

Line 221: FROM ra_customer_trx_all A, ra_customer_trx_all B

217: --Start
218: IF l_batch_source_id IS NULL THEN
219:
220: SELECT B.batch_source_id INTO temp1
221: FROM ra_customer_trx_all A, ra_customer_trx_all B
222: WHERE A.RECURRED_FROM_TRX_NUMBER = B.trx_number
223: AND A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;
224: BEGIN
225:

Line 275: UPDATE ra_customer_trx_all

271: -- bug 10038807 End
272: END LOOP;
273:
274: FORALL j IN customer_trx_id.FIRST .. customer_trx_id.LAST
275: UPDATE ra_customer_trx_all
276: SET trx_number = trx_number(j),
277: global_attribute16 = global_attribute16(j), --bug 10038807
278: global_attribute17 = l_cai_num,
279: global_attribute18 = l_cai_due_date

Line 304: From ra_customer_trx_all A, ra_customer_trx_all B

300: If l_batch_source_id IS NULL THEN
301:
302: /*Select B.batch_source_id
303: into temp1
304: From ra_customer_trx_all A, ra_customer_trx_all B
305: Where A.recurred_from_trx_number = B.trx_number
306: And A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;*/
307:
308: Select batch_source_ID INTO temp1 from ra_customer_trx_all

Line 308: Select batch_source_ID INTO temp1 from ra_customer_trx_all

304: From ra_customer_trx_all A, ra_customer_trx_all B
305: Where A.recurred_from_trx_number = B.trx_number
306: And A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;*/
307:
308: Select batch_source_ID INTO temp1 from ra_customer_trx_all
309: where customer_trx_id = customer_trx_id(1);
310:
311: Begin
312: Select GLOBAL_ATTRIBUTE1

Line 374: UPDATE ra_customer_trx_all

370: END IF;
371: END LOOP;
372:
373: FORALL j IN customer_trx_id.FIRST .. customer_trx_id.LAST
374: UPDATE ra_customer_trx_all
375: SET trx_number = trx_number(j)
376: WHERE customer_trx_id = customer_trx_id(j)
377: AND request_id = p_request_id;
378: End If;

Line 392: FROM ra_customer_trx_all l

388:
389: PROCEDURE val_trx_range (p_request_id IN Number, p_flag OUT NOCOPY Number) IS
390: CURSOR C_Trx_Lines IS
391: SELECT l.customer_trx_id
392: FROM ra_customer_trx_all l
393: WHERE l.request_id = p_request_id
394: --And l.complete_flag = 'Y'
395: AND l.customer_trx_id IS NOT NULL;
396:

Line 404: TYPE trx_id IS TABLE OF ra_customer_trx_all.customer_trx_id%Type;

400: WHERE A.customer_trx_id = p_trx_id AND
401: A.customer_trx_line_id = B.customer_trx_line_id
402: AND ROWNUM = 1;
403:
404: TYPE trx_id IS TABLE OF ra_customer_trx_all.customer_trx_id%Type;
405:
406: customer_trx_id trx_id;
407:
408: l_batch_source_id Number;

Line 543: From ra_customer_trx_all l

539:
540: -- Cursor to identify Transaction Number from Trx_ID
541: Cursor C_Trx_Lines (x_trx_id Number) Is
542: Select l.trx_number,l.batch_source_id
543: From ra_customer_trx_all l
544: Where l.customer_trx_id = x_trx_id
545: And l.complete_flag = 'Y'
546: And l.customer_trx_id Is Not Null;
547:

Line 580: From ra_customer_trx_all l

576: Cursor C_AR_Trx_Lines (x_trx_id Number) Is
577: Select l.trx_number,
578: l.batch_source_id,
579: nvl(l.cust_trx_type_id,0)
580: From ra_customer_trx_all l
581: Where l.customer_trx_id = x_trx_id
582: And l.complete_flag = 'Y';
583: -- Bug 12595382 End
584:

Line 585: l_trx_number ra_customer_trx_all.trx_number%Type;

581: Where l.customer_trx_id = x_trx_id
582: And l.complete_flag = 'Y';
583: -- Bug 12595382 End
584:
585: l_trx_number ra_customer_trx_all.trx_number%Type;
586: l_batch_source_type ra_batch_sources_all.batch_source_type%Type;
587: f_batch_source_id ra_batch_sources_all.batch_source_id%Type;
588: l_batch_source_id ra_batch_sources_all.batch_source_id%Type;
589: l_auto_trx_num_flag ra_batch_sources_all.auto_trx_numbering_flag%Type;

Line 599: l_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%Type;

595: l_debug_loc Varchar2(400);
596: l_country_code Varchar2(30);
597: f_org_id Varchar2(15);
598: -- Bug 12595382 Start
599: l_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%Type;
600: l_legal_entity_id ra_batch_sources_all.legal_entity_id%Type;
601: l_branch_number Varchar2(4);
602: l_document_letter Varchar2(1);
603: l_cai_num ra_batch_sources_all.global_attribute8%Type;

Line 605: l_num_bar_code ra_customer_trx_all.global_attribute16%Type;

601: l_branch_number Varchar2(4);
602: l_document_letter Varchar2(1);
603: l_cai_num ra_batch_sources_all.global_attribute8%Type;
604: l_cai_due_date ra_batch_sources_all.global_attribute9%Type;
605: l_num_bar_code ra_customer_trx_all.global_attribute16%Type;
606: -- Bug 12595382 End
607:
608: FATAL_ERROR Exception;
609: GET_BATCH_ID_ERR Exception;

Line 667: Update ra_customer_trx_all

663: If l_auto_trx_num_flag = 'Y' AND NVL(l_copy_doc_number_flag,'N') = 'N' Then -- Automatic Numbering
664: l_debug_loc := 'Getting Next Sequence number';
665: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
666: If l_err_code = 0 Then
667: Update ra_customer_trx_all
668: Set trx_number = l_seq_number
669: Where customer_trx_id = p_trx_id;
670: End If;
671: End If;

Line 747: Update ra_customer_trx_all

743: JL_ZZ_AR_LIBRARY_1_PKG.get_next_seq_number (l_seq_name, l_seq_number,1,l_err_code);
744: If l_err_code = 0 THEN
745: l_debug_loc := 'Generating the new AR Transaction Number';
746: l_trx_number := l_document_letter || '-' || l_branch_number || '-' || lpad(l_seq_number,8,'0');
747: Update ra_customer_trx_all
748: Set trx_number = l_trx_number,
749: global_attribute16 = l_num_bar_code,
750: global_attribute17 = l_cai_num,
751: global_attribute18 = l_cai_due_date

Line 821: FROM RA_CUSTOMER_TRX_ALL r

817: --Bug 13716737: Modified following SQL statement
818:
819: SELECT TRUNC(NVL(MAX(r.TRX_DATE),SYSDATE))
820: INTO l_max_trx_date
821: FROM RA_CUSTOMER_TRX_ALL r
822: WHERE r.batch_source_id in (
823: SELECT b.batch_source_id
824: FROM RA_BATCH_SOURCES_ALL b
825: WHERE b.batch_source_id = l_batch_source_id