DBA Data[Home] [Help]

APPS.AMS_IMPORT_XML_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 894: FROM ams_list_src_fields A, ams_imp_list_headers_all b

890: l_dom_actual_root xmldom.DOMNode;
891:
892: CURSOR c_import_source_fields (p_import_list_header_id NUMBER) IS
893: SELECT A.SOURCE_COLUMN_NAME
894: FROM ams_list_src_fields A, ams_imp_list_headers_all b
895: WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
896: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
897: ORDER BY LIST_SOURCE_FIELD_ID;
898:

Line 1101: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1097: l_dom_actual_root xmldom.DOMNode;
1098:
1099: CURSOR c_import_mapping_fields (p_import_list_header_id NUMBER) IS
1100: SELECT A.SOURCE_COLUMN_NAME, A.FIELD_COLUMN_NAME
1101: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1102: WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
1103: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1104: ORDER BY LIST_SOURCE_FIELD_ID;
1105: