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_BATCH_SOURCES_ALL

Line 74: FROM ra_batch_sources_all

70: global_attribute9,
71: nvl(decode(batch_source_type, 'INV', to_number(global_attribute1),
72: batch_source_id),0), --bug 10038807
73: nvl(legal_entity_id,0) --bug 10038807
74: FROM ra_batch_sources_all
75: WHERE batch_source_id = p_batch_source_id
76: AND org_id = p_org_id;
77:
78: -- Start Bug 8982308

Line 84: FROM ra_batch_sources_all

80: l_copy_doc_number_flag VARCHAR2(1) := NULL; -- 9090969
81:
82: CURSOR C_BR_Batch_Details (l_batch_source_id Number,l_org_id Number) IS
83: SELECT auto_trx_numbering_flag , copy_doc_number_flag -- 9090969
84: FROM ra_batch_sources_all
85: WHERE batch_source_id = l_batch_source_id
86: and org_id = l_org_id;
87: -- End Bug 8982308
88:

Line 92: FROM ra_batch_sources_all rbc_1

88:
89: -- Start Bug 8709620
90: CURSOR C_BR_Imp_Batch_Source (p_batch_source_id In Number, p_org_id In Number) IS
91: SELECT rbc_1.global_attribute1 imp_batch_source_id
92: FROM ra_batch_sources_all rbc_1
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:

Line 167: SELECT COPY_DOC_NUMBER_FLAG INTO l_copy_doc_num_flag FROM RA_BATCH_SOURCES_ALL

163:
164: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);
165:
166: BEGIN
167: SELECT COPY_DOC_NUMBER_FLAG INTO l_copy_doc_num_flag FROM RA_BATCH_SOURCES_ALL
168: WHERE BATCH_SOURCE_ID = l_batch_source_id
169: AND ORG_ID = l_org_id;
170: EXCEPTION
171: WHEN OTHERS THEN

Line 227: FROM RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = temp1;

223: AND A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;
224: BEGIN
225:
226: SELECT GLOBAL_ATTRIBUTE1 INTO temp2
227: FROM RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = temp1;
228: EXCEPTION
229: WHEN NO_DATA_FOUND THEN
230: null;
231: END;

Line 314: From RA_BATCH_SOURCES_ALL

310:
311: Begin
312: Select GLOBAL_ATTRIBUTE1
313: Into temp2
314: From RA_BATCH_SOURCES_ALL
315: Where BATCH_SOURCE_ID = temp1;
316: Exception
317: When NO_DATA_FOUND THEN
318: null;

Line 445: SELECT COPY_DOC_NUMBER_FLAG INTO l_copy_doc_num_flag FROM RA_BATCH_SOURCES_ALL

441: null;
442: END;
443:
444: BEGIN
445: SELECT COPY_DOC_NUMBER_FLAG INTO l_copy_doc_num_flag FROM RA_BATCH_SOURCES_ALL
446: WHERE BATCH_SOURCE_ID = l_batch_source_id
447: AND ORG_ID = l_org_id;
448: EXCEPTION
449: WHEN OTHERS THEN

Line 464: FROM RA_BATCH_SOURCES_ALL

460: CLOSE C_Trx_lines;
461:
462:
463: SELECT name INTO l_batch_source_name
464: FROM RA_BATCH_SOURCES_ALL
465: WHERE batch_source_id = l_batch_source_id;
466:
467: l_debug_loc := 'Getting Transaction Source details';
468: ja_tw_sh_gui_utils.get_trx_src_info(

Line 551: From ra_batch_sources_all

547:
548: -- Cursor to identify if automatic transaction numbering is enabled for the batch source
549: Cursor C_BR_Batch_Details (p_batch_source_id Number, p_org_id Number) IS
550: Select auto_trx_numbering_flag,copy_doc_number_flag
551: From ra_batch_sources_all
552: Where batch_source_id = p_batch_source_id
553: And org_id = p_org_id;
554:
555: -- Cursor to identify Transaction Batch Source Type

Line 560: From ra_batch_sources_all

556: -- Bug 12595382 Start Changed the Name of the cursor
557: Cursor C_Batch_Source_Type (p_batch_source_id Number, p_org_id Number) IS
558: -- Bug 12595382 End
559: Select Batch_Source_Type
560: From ra_batch_sources_all
561: Where batch_source_id = p_batch_source_id
562: And org_id = p_org_id;
563:
564: -- Bug 12595382 Start

Line 572: From ra_batch_sources_all

568: auto_trx_numbering_flag,
569: global_attribute8,
570: global_attribute9,
571: nvl(legal_entity_id,0)
572: From ra_batch_sources_all
573: Where batch_source_id = p_batch_source_id
574: And org_id = p_org_id;
575:
576: Cursor C_AR_Trx_Lines (x_trx_id Number) Is

Line 586: l_batch_source_type ra_batch_sources_all.batch_source_type%Type;

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;
590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%Type;

Line 587: f_batch_source_id ra_batch_sources_all.batch_source_id%Type;

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;
590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%Type;
591: l_seq_number Number;

Line 588: l_batch_source_id ra_batch_sources_all.batch_source_id%Type;

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;
590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%Type;
591: l_seq_number Number;
592: l_err_code Number;

Line 589: l_auto_trx_num_flag ra_batch_sources_all.auto_trx_numbering_flag%Type;

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;
590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%Type;
591: l_seq_number Number;
592: l_err_code Number;
593: l_err_code1 Number;

Line 590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%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;
590: l_copy_doc_number_flag ra_batch_sources_all.copy_doc_number_flag%Type;
591: l_seq_number Number;
592: l_err_code Number;
593: l_err_code1 Number;
594: l_seq_name Varchar2(30);

Line 600: l_legal_entity_id ra_batch_sources_all.legal_entity_id%Type;

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;
604: l_cai_due_date ra_batch_sources_all.global_attribute9%Type;

Line 603: l_cai_num ra_batch_sources_all.global_attribute8%Type;

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;
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:

Line 604: l_cai_due_date ra_batch_sources_all.global_attribute9%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;
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;

Line 809: FROM RA_BATCH_SOURCES_ALL b

805: l_error_msg := 'Error retrieving Batch_Source_Id...';
806:
807: SELECT b.batch_source_id
808: INTO l_batch_source_id
809: FROM RA_BATCH_SOURCES_ALL b
810: WHERE b.name = batch_source_name(i)
811: AND b.org_id = org_id(i);
812:
813: l_error_msg := '';

Line 824: FROM RA_BATCH_SOURCES_ALL b

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
826: AND b.org_id = org_id(i)
827: UNION
828: SELECT c.batch_source_id

Line 829: FROM RA_BATCH_SOURCES_ALL c

825: WHERE b.batch_source_id = l_batch_source_id
826: AND b.org_id = org_id(i)
827: UNION
828: SELECT c.batch_source_id
829: FROM RA_BATCH_SOURCES_ALL c
830: WHERE c.global_attribute1 = l_batch_source_id
831: AND c.batch_source_type = 'INV'
832: AND c.org_id = org_id(i))
833: AND r.org_id = org_id(i);