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.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on HZ_PARTIES

Line 423: ''HZ_PARTIES'',

419: :program_id,
420: :l_sysdate,
421: :request_id,
422: code_assignment_id,
423: ''HZ_PARTIES'',
424: party_id,
425: class_category,
426: class_code,
427: nvl(primary_flag, ''N''),

Line 513: hz_parties hp,

509: hz_imp_classifics_int cai,
510: fnd_lookup_values class_code_lookups,
511: hz_class_categories class_cat,
512: tc tc1, tc tc2, tc tc3,
513: hz_parties hp,
514: fnd_lookup_values createdby_l
515:
516: where hp.party_id (+) = cas.party_id
517: AND hp.status (+) = ''A''

Line 539: and c.owner_table_name = ''HZ_PARTIES''

535: and tc1.a = (select count(*) -- check date overlap, 0 indicates no error
536: from hz_code_assignments c
537: where c.class_category = cai.class_category
538: and c.class_code = cai.class_code
539: and c.owner_table_name = ''HZ_PARTIES''
540: and c.owner_table_id = cas.party_id
541: and nvl(cai.end_date_active, :l_no_end_date) >=
542: c.start_date_active
543: and nvl(c.end_date_active, :l_no_end_date) >=

Line 555: and c_assign.owner_table_name = ''HZ_PARTIES''

551: hz_class_categories c_cat
552: where c_cat.class_category = c_assign.class_category
553: and c_cat.class_category = cai.class_category
554: and c_assign.owner_table_id = cas.party_id
555: and c_assign.owner_table_name = ''HZ_PARTIES''
556: and c_cat.allow_multi_assign_flag = ''N''
557: and nvl(cai.end_date_active, :l_no_end_date) >=
558: c_assign.start_date_active
559: and nvl(c_assign.end_date_active, :l_no_end_date) >=

Line 857: hz_parties hp

853: cls_sg.party_id, cls_sg.class_category order by
854: cls_sg.code_assignment_id) r
855: from HZ_IMP_TMP_ERRORS err_table,
856: hz_imp_classifics_sg cls_sg,
857: hz_parties hp
858: where err_table.request_id = :request_id
859: and err_table.interface_table_name = ''HZ_IMP_CLASSIFICS_INT''
860: and cls_sg.batch_id = :batch_id
861: and cls_sg.batch_mode_flag = :batch_mode_flag

Line 880: -- nullify denorm column in hz_parties

876: l_error_party_id, l_error_class_category;
877:
878: close primary_flag_err_cursor;
879:
880: -- nullify denorm column in hz_parties
881: /* Bug 409189: when checking class_category in hz_imp_classifics_sg,
882: check for 'SIC' instead of the individual SIC code type as this is how
883: matching populates the column */
884: forall i in 1..l_error_party_id.count

Line 885: update hz_parties hz_pty

881: /* Bug 409189: when checking class_category in hz_imp_classifics_sg,
882: check for 'SIC' instead of the individual SIC code type as this is how
883: matching populates the column */
884: forall i in 1..l_error_party_id.count
885: update hz_parties hz_pty
886: set category_code = decode(l_error_class_category(i), 'CUSTOMER_CATEGORY', null, category_code),
887: sic_code_type = decode(l_error_class_category(i), 'SIC', null, sic_code_type),
888: sic_code = decode(l_error_class_category(i), 'SIC', null, sic_code)
889: where hz_pty.party_id = l_error_party_id(i);

Line 991: -- de-norm to hz_parties

987: fetch pid_cursor INTO
988: l_update_max_party_id, l_update_min_party_id;
989:
990:
991: -- de-norm to hz_parties
992: forall i in 1..l_update_party_id.count
993: update hz_parties hz_pty
994: set category_code = decode(l_update_class_category(i), 'CUSTOMER_CATEGORY', l_update_class_code(i), category_code),
995: sic_code_type = decode(l_update_class_category(i), 'SIC', l_update_int_class_category(i), sic_code_type),

Line 993: update hz_parties hz_pty

989:
990:
991: -- de-norm to hz_parties
992: forall i in 1..l_update_party_id.count
993: update hz_parties hz_pty
994: set category_code = decode(l_update_class_category(i), 'CUSTOMER_CATEGORY', l_update_class_code(i), category_code),
995: sic_code_type = decode(l_update_class_category(i), 'SIC', l_update_int_class_category(i), sic_code_type),
996: sic_code = decode(l_update_class_category(i), 'SIC', l_update_class_code(i), sic_code)
997: where hz_pty.party_id = l_update_party_id(i);

Line 1122: and c.owner_table_name = ''HZ_PARTIES''

1118: from hz_code_assignments c
1119: where c.code_assignment_id <> cas.code_assignment_id
1120: and c.class_category = cas.class_category
1121: and c.class_code = cas.class_code
1122: and c.owner_table_name = ''HZ_PARTIES''
1123: and c.owner_table_id = cas.party_id
1124: and nvl(cai.end_date_active, :l_no_end_date) >=
1125: c.start_date_active
1126: and nvl(c.end_date_active, :l_no_end_date) >=

Line 1138: and c_assign.owner_table_name = ''HZ_PARTIES''

1134: hz_class_categories c_cat
1135: where c_cat.class_category = c_assign.class_category
1136: and c_cat.class_category = cas.class_category
1137: and c_assign.owner_table_id = cas.party_id
1138: and c_assign.owner_table_name = ''HZ_PARTIES''
1139: and c_cat.allow_multi_assign_flag = ''N''
1140: and nvl(cai.end_date_active, :l_no_end_date) >=
1141: c_assign.start_date_active
1142: and nvl(c_assign.end_date_active, :l_no_end_date) >=