83: SELECT pos_hz_party_site_bo(NULL, -- COMMON_OBJ_ID
84: ps.party_site_id,
85: NULL, --PS.ORIG_SYSTEM,
86: NULL, --PS.ORIG_SYSTEM_REFERENCE,
87: hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
88: ps.party_id),
89: ps.party_id,
90: ps.party_site_number,
91: ps.mailstop,
116: ps.language,
117: ps.addressee,
118: ps.program_update_date,
119: ps.created_by_module,
120: hz_extract_bo_util_pvt.get_user_name(ps.created_by),
121: ps.creation_date,
122: ps.last_update_date,
123: hz_extract_bo_util_pvt.get_user_name(ps.last_updated_by),
124: ps.actual_content_source,
119: ps.created_by_module,
120: hz_extract_bo_util_pvt.get_user_name(ps.created_by),
121: ps.creation_date,
122: ps.last_update_date,
123: hz_extract_bo_util_pvt.get_user_name(ps.last_updated_by),
124: ps.actual_content_source,
125: ps.global_location_number,
126: pos_supplier_uda_bo_pkg.get_uda_for_supplier_site(p_party_id,
127: ps.party_site_id,