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

Line 9: G_PARTY_ID hz_parties.party_id%TYPE;

5: G_SEARCH_STMT LONG;
6: G_PKG_NAME VARCHAR2(30);
7: G_FILE_NAME VARCHAR2(12);
8: G_USER_ID fnd_user.user_id%TYPE;
9: G_PARTY_ID hz_parties.party_id%TYPE;
10: G_LOGIN_ID fnd_user.last_update_login%TYPE;
11: G_SESSION_LANG VARCHAR2(99);
12:
13:

Line 204: l_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';

200: l_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ';
201: l_suppl_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ) ';
202: l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
203: l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
204: l_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
205: l_suppl_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
206: l_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';
207: l_suppl_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';
208: -- Add site related query if the search site flag is set

Line 205: l_suppl_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';

201: l_suppl_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ) ';
202: l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
203: l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';
204: l_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
205: l_suppl_from_clause := ' FROM ap_suppliers aas, hz_parties hp ';
206: l_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';
207: l_suppl_where_clause := ' WHERE aas.party_id = hp.party_id AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE ';
208: -- Add site related query if the search site flag is set
209: IF p_search_sites = fnd_api.G_TRUE THEN