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.AMS_LIST_IMPORT_PUB dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 355: select rented_list_flag, nvl(RECORD_UPDATE_FLAG,'N') from ams_imp_list_headers_all

351:
352:
353:
354: cursor c_rented is
355: select rented_list_flag, nvl(RECORD_UPDATE_FLAG,'N') from ams_imp_list_headers_all
356: where import_list_header_id = p_import_list_header_id;
357:
358:
359: cursor b2bxml is

Line 3295: from ams_imp_list_headers_all

3291:
3292:
3293: cursor c_imp_type is
3294: select import_type, batch_id, nvl(ERROR_THRESHOLD,0)
3295: from ams_imp_list_headers_all
3296: where import_list_header_id = p_import_list_header_id;
3297:
3298: cursor c_error_exists is
3299: select 'Y'

Line 3465: UPDATE ams_imp_list_headers_all

3461: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3462: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3463: system_status_code = 'ERROR' and default_flag = 'Y';
3464:
3465: UPDATE ams_imp_list_headers_all
3466: set status_code = l_lookup_code,
3467: user_status_id = l_user_status_id,
3468: status_date = sysdate
3469: where import_list_header_id = p_import_list_header_id;

Line 4324: ams_imp_list_headers_all header

4320: LINE.COL248,
4321: LINE.COL249,
4322: LINE.COL250
4323: from ams_imp_source_lines line,
4324: ams_imp_list_headers_all header
4325: where line.import_source_line_id = p_import_source_line_id
4326: and line.import_list_header_id = p_import_list_header_id
4327: and line.import_list_header_id = header.import_list_header_id;
4328:

Line 5097: select import_type from ams_imp_list_headers_all

5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5095:
5096: cursor c_imp_type is
5097: select import_type from ams_imp_list_headers_all
5098: where import_list_header_id = p_import_list_header_id;
5099:
5100: begin
5101: open c_imp_type;

Line 5280: select import_type from ams_imp_list_headers_all

5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5278:
5279: cursor c_imp_type is
5280: select import_type from ams_imp_list_headers_all
5281: where import_list_header_id = p_import_list_header_id;
5282:
5283: begin
5284: open c_imp_type;