APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_PARTY_SITES

Line 243: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'

239: UPDATE ap_supplier_sites_int supp
240: SET party_site_id =
241: (SELECT owner_table_id
242: FROM hz_orig_sys_references hr
243: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
244: AND hr.party_id = supp.party_id -- Bug 14772702: Same site orig reference can exist under different suppliers
245: AND hr.orig_system = supp.party_site_orig_system
246: AND hr.orig_system_reference =
247: supp.party_site_orig_sys_reference

Line 1103: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'

1099: UPDATE ap_supplier_sites_int supp
1100: SET party_site_id =
1101: (SELECT owner_table_id
1102: FROM hz_orig_sys_references hr
1103: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
1104: AND hr.orig_system = supp.party_site_orig_system
1105: AND hr.orig_system_reference =
1106: supp.party_site_orig_sys_reference
1107: AND hr.status = 'A'

Line 3987: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'

3983: BEGIN
3984: SELECT owner_table_id
3985: INTO vendor_contact_rec.org_party_site_id
3986: FROM hz_orig_sys_references hr
3987: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
3988: AND hr.orig_system = contact_int_rec.party_site_orig_system
3989: AND hr.orig_system_reference =
3990: contact_int_rec.party_site_orig_sys_reference
3991: AND hr.status = 'A'

Line 4149: FROM hz_party_sites

4145: ELSIF (vendor_contact_rec.party_site_name IS NOT NULL) THEN
4146: BEGIN
4147: SELECT party_site_id
4148: INTO vendor_contact_rec.org_party_site_id
4149: FROM hz_party_sites
4150: WHERE party_id = contact_int_rec.party_id
4151: AND party_site_name = vendor_contact_rec.party_site_name;
4152:
4153: EXCEPTION

Line 8996: AND owner_table_name = 'HZ_PARTY_SITES'

8992: FROM hz_orig_sys_references
8993: WHERE orig_system = bank_account_dtls_rec.party_site_orig_sys
8994: AND orig_system_reference =
8995: bank_account_dtls_rec.party_site_orig_sys_ref
8996: AND owner_table_name = 'HZ_PARTY_SITES'
8997: AND nvl(end_date_active, SYSDATE) >= SYSDATE;
8998: END IF;
8999:
9000: fnd_file.put_line(fnd_file.log,

Line 9010: FROM hz_party_sites hps,

9006: /*, hps.party_site_name, hzl.address1, hzl.address2, hzl.address3, hzl.address4,
9007: hzl.state, hzl.province, hzl.county, hzl.country, fvl.territory_short_name as country_name
9008: , hzl.city , hzl.postal_code*/
9009: INTO l_party_site_id
9010: FROM hz_party_sites hps,
9011: hz_locations hzl,
9012: fnd_territories_vl fvl
9013: WHERE hps.party_id = l_party_id
9014: AND hzl.location_id = hps.location_id