[Home] [Help]
58: substr(bne_lct_tools_pkg.app_id_to_asn(s.application_id),1,30),
59: s.object_code,
60: s.object_type,
61: v.display_flag
62: from bne_integrators_vl v, bne_secured_objects s, fnd_application a
63: where v.application_id = a.application_id
64: and v.application_id = s.application_id (+)
65: and v.integrator_code = s.object_code (+)
66: and s.object_type (+) = 'INTEGRATOR'
81: v.upload_param_list_code,
82: v.upload_order,
83: v.user_name,
84: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
85: from bne_interfaces_vl v, fnd_application a
86: where v.application_id = a.application_id
87: and v.integrator_code = p_integrator_code
88: and a.application_short_name = 'PER'
89: order by a.application_short_name, v.interface_code;
137: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_query_app_id),1,30) val_query_asn,
138: v.val_query_code,
139: substr(bne_lct_tools_pkg.app_id_to_asn(v.expanded_sql_query_app_id),1,30) expanded_sql_query_asn,
140: v.expanded_sql_query_code
141: from bne_interface_cols_vl v, fnd_application a
142: where v.application_id = a.application_id
143: and v.interface_code = v_interface_code
144: and a.application_short_name = 'PER'
145: order by a.application_short_name, v.interface_code, v.sequence_num;
154: v.content_class,
155: v.user_name,
156: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
157: v.once_only_download_flag
158: from bne_contents_vl v, fnd_application a
159: where v.integrator_app_id = a.application_id
160: and v.integrator_code = p_integrator_code
161: and a.application_short_name = 'PER'
162: order by a.application_short_name, v.content_code;
169: v.col_name,
170: v.user_name,
171: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
172: v.read_only_flag
173: from bne_content_cols_vl v, fnd_application a
174: where v.application_id = a.application_id
175: and v.content_code = v_content_code
176: and a.application_short_name = 'PER'
177: order by a.application_short_name, v.content_code, v.sequence_num;
183: substr(bne_lct_tools_pkg.app_id_to_asn(v.query_app_id),1,30) bne_query_query_asn,
184: v.query_code,
185: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
186: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
187: from bne_stored_sql v, fnd_application a
188: where v.application_id = a.application_id
189: and v.content_code = v_content_code
190: and a.application_short_name = 'PER';
191:
198: v.user_name,
199: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
200: v.object_version_number,
201: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
202: from bne_mappings_vl v, fnd_application a
203: where v.application_id = a.application_id
204: and v.integrator_code = p_integrator_code
205: and a.application_short_name = 'PER'
206: order by a.application_short_name, v.mapping_code;
217: substr(bne_lct_tools_pkg.app_id_to_asn(v.content_app_id),1,30) content_asn,
218: v.content_code,
219: v.content_seq_num,
220: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
221: from bne_mapping_lines v, fnd_application a
222: where v.application_id = a.application_id
223: and v.mapping_code = v_mapping_code
224: and a.application_short_name = 'PER'
225: order by a.application_short_name, v.mapping_code, v.sequence_num;
239: v.user_name,
240: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
241: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_list_asn,
242: v.create_doc_list_code
243: from bne_layouts_vl v, fnd_application a
244: where v.integrator_app_id = a.application_id
245: and v.integrator_code like p_integrator_code
246: and a.application_short_name like 'PER'
247: order by a.application_short_name, v.layout_code desc;
281: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
282: v.title_style_class,
283: v.title_style,
284: v.prompt_above
285: from bne_layout_blocks_vl v, fnd_application a
286: where v.application_id = a.application_id
287: and v.layout_code = v_layout_code
288: and a.application_short_name = 'PER'
289: order by a.application_short_name, v.layout_code, v.block_id;
307: v.default_type,
308: v.display_width,
309: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
310: v.read_only_flag
311: from bne_layout_cols v, fnd_application a
312: where v.application_id = a.application_id
313: and v.layout_code = v_layout_code
314: and a.application_short_name = 'PER'
315: and v.block_id = v_block_id
324: v.security_rule_code rule_security_rule_code,
325: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
326: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
327: v.security_rule_app_id
328: from bne_secured_objects v, fnd_application a
329: where v.application_id = a.application_id
330: and v.object_code = p_integrator_code
331: and v.object_type = 'INTEGRATOR'
332: and a.application_short_name = 'PER'
340: v.security_type,
341: v.security_value,
342: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
343: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
344: from bne_security_rules v, fnd_application a
345: where v.application_id = a.application_id
346: and v.security_code = v_security_rule_code
347: and a.application_short_name = 'PER'
348: order by a.application_short_name, v.security_code;