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_LISTIMPORT_PVT dependencies on AMS_IMP_DOCUMENTS

Line 3464: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;

3460: L_MESG_TEXT VARCHAR2(2000);
3461:
3462:
3463: cursor c_file_type is
3464: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
3465:
3466: cursor c_imptype is
3467: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3468:

Line 3614: select file_size, file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;

3610: L_MESG_TEXT varchar2(2000);
3611: L_LOOKUP_CODE varchar2(30);
3612:
3613: cursor c_prof_file_size is
3614: select file_size, file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
3615:
3616: cursor c_imptype is
3617: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3618:

Line 3767: select file_type from ams_imp_documents

3763: WHERE import_list_header_id = p_import_list_header_id
3764: AND load_status <> 'DUPLICATE';
3765:
3766: cursor c_file_type is
3767: select file_type from ams_imp_documents
3768: where import_list_header_id = p_import_list_header_id;
3769:
3770: cursor c_dup_recs is
3771: select COL68 from ams_imp_source_lines

Line 7741: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;

7737: select per_imp_xml_element_id, add_imp_xml_element_id,cp_imp_xml_element_id, em_imp_xml_element_id
7738: from ams_hz_b2c_mapping_v where import_source_line_id = p_import_source_line_id;
7739:
7740: cursor c_file_type is
7741: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
7742:
7743: begin
7744: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATE_VAL_ERROR_CHK');
7745: l_invalid_date := FND_MESSAGE.get;

Line 13701: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d

13697: and load_status in ('ACTIVE','RELOAD')
13698: and rownum < 2;
13699:
13700: cursor c_rec_in_xml_stag_tab is
13701: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d
13702: where d.import_list_header_id = p_import_list_header_id
13703: and d.imp_document_id = e.imp_xml_document_id
13704: and e.load_status in ('ACTIVE','RELOAD')
13705: and rownum < 2;

Line 13722: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;

13718: SELECT concurrent_program FROM ams_imp_list_import_types
13719: where import_type = x_imp_type;
13720:
13721: cursor c_file_type is
13722: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
13723:
13724: cursor c_total_records is
13725: select count(*) from ams_imp_source_lines
13726: where import_list_header_id = p_import_list_header_id

Line 20925: select file_type from ams_imp_documents

20921: where import_list_header_id = p_import_list_header_id
20922: and load_status = G_STATUS_DUPLICATE;
20923:
20924: cursor c_file_type is
20925: select file_type from ams_imp_documents
20926: where import_list_header_id = p_import_list_header_id;
20927:
20928: cursor c_dup_xml_recs is
20929: select COL68 from ams_imp_source_lines