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 3302: from ams_imp_list_headers_all

3298:
3299:
3300: cursor c_imp_type is
3301: select import_type, batch_id, nvl(ERROR_THRESHOLD,0)
3302: from ams_imp_list_headers_all
3303: where import_list_header_id = p_import_list_header_id;
3304:
3305: cursor c_error_exists is
3306: select 'Y'

Line 3472: UPDATE ams_imp_list_headers_all

3468: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3469: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3470: system_status_code = 'ERROR' and default_flag = 'Y';
3471:
3472: UPDATE ams_imp_list_headers_all
3473: set status_code = l_lookup_code,
3474: user_status_id = l_user_status_id,
3475: status_date = sysdate
3476: where import_list_header_id = p_import_list_header_id;

Line 4331: ams_imp_list_headers_all header

4327: LINE.COL248,
4328: LINE.COL249,
4329: LINE.COL250
4330: from ams_imp_source_lines line,
4331: ams_imp_list_headers_all header
4332: where line.import_source_line_id = p_import_source_line_id
4333: and line.import_list_header_id = p_import_list_header_id
4334: and line.import_list_header_id = header.import_list_header_id;
4335:

Line 5104: select import_type from ams_imp_list_headers_all

5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5102:
5103: cursor c_imp_type is
5104: select import_type from ams_imp_list_headers_all
5105: where import_list_header_id = p_import_list_header_id;
5106:
5107: begin
5108: open c_imp_type;

Line 5287: select import_type from ams_imp_list_headers_all

5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5285:
5286: cursor c_imp_type is
5287: select import_type from ams_imp_list_headers_all
5288: where import_list_header_id = p_import_list_header_id;
5289:
5290: begin
5291: open c_imp_type;