DBA Data[Home] [Help]

APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on RA_BATCH_SOURCES_ALL

Line 58: FROM ra_batch_sources_all

54: substr(global_attribute3,1,1),
55: auto_trx_numbering_flag,
56: global_attribute8,
57: global_attribute9
58: FROM ra_batch_sources_all
59: WHERE batch_source_id = l_batch_source_id;
60:
61: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
62: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;

Line 167: FROM RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = temp1;

163: AND A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;
164: BEGIN
165:
166: SELECT GLOBAL_ATTRIBUTE1 INTO temp2
167: FROM RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = temp1;
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN
170: null;
171: END;

Line 280: FROM RA_BATCH_SOURCES_ALL

276: FROM fnd_concurrent_requests cr
277: WHERE request_id = p_request_id;
278:
279: SELECT name INTO l_batch_source_name
280: FROM RA_BATCH_SOURCES_ALL
281: WHERE batch_source_id = l_batch_source_id;
282:
283: l_debug_loc := 'Getting Transaction Source details';
284: ja_tw_sh_gui_utils.get_trx_src_info(