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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_PARTY_SITES

Line 1154: from hz_party_sites where party_id = p_party_id and status = 'A'));

1150: where site_use_type = 'SHIP_TO'
1151: and primary_per_type = 'Y'
1152: and (party_site_id in
1153: (select party_site_id
1154: from hz_party_sites where party_id = p_party_id and status = 'A'));
1155:
1156: cursor cr_get_primary_bill_to_id (v_address_id number) is
1157: select site_use_id
1158: from HZ_CUST_SITE_USES

Line 2881: s_Status hz_party_sites.Status%TYPE := 'A';

2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;

Line 2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;

2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:
2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';

Line 2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;

2938:
2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2946: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;

Line 2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;

2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2946: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2947: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;

Line 2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;

2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2946: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2947: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;
2948: s_su_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE := 'Y';

Line 2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';

2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2945: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2946: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2947: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;
2948: s_su_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE := 'Y';
2949: s_su_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE := 'Y';

Line 2978: t_party_site_id hz_party_sites.party_site_id%TYPE;

2974: t_last_update_date DATE;
2975: t_party_site_last_update_date DATE;
2976: t_loc_last_update_date DATE;
2977: t_party_id hz_cust_accounts.party_id%TYPE;
2978: t_party_site_id hz_party_sites.party_site_id%TYPE;
2979: t_party_site_number hz_party_sites.party_site_number%TYPE;
2980: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2981: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;
2982: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE;

Line 2979: t_party_site_number hz_party_sites.party_site_number%TYPE;

2975: t_party_site_last_update_date DATE;
2976: t_loc_last_update_date DATE;
2977: t_party_id hz_cust_accounts.party_id%TYPE;
2978: t_party_site_id hz_party_sites.party_site_id%TYPE;
2979: t_party_site_number hz_party_sites.party_site_number%TYPE;
2980: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2981: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;
2982: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE;
2983: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE;

Line 3057: select hz_party_sites_s.nextval from dual;

3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055:
3056: CURSOR l_party_site_number_csr IS
3057: select hz_party_sites_s.nextval from dual;
3058:
3059: CURSOR l_po_loc_association_csr IS
3060: select p.customer_id,
3061: p.address_id,

Line 3083: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps

3079: c.translated_customer_name,
3080: c.last_update_date,
3081: ps.last_update_date,
3082: z.last_update_date
3083: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps
3084: where p.address_id = c.cust_acct_site_id and c.party_site_id = ps.party_site_id and ps.location_id = z.location_id and p.location_id = l_inv_location_id;
3085:
3086: CURSOR l_inv_loc_csr IS
3087: select address_line_1, address_line_2, address_line_3, town_or_city, country, postal_code, region_1, region_2, region_3, attribute_category,

Line 3095: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';

3091: global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14,
3092: global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20 from hr_locations where location_id = l_inv_location_id;
3093:
3094: CURSOR l_identify_address_flag_csr IS
3095: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';
3096:
3097: Cursor province_enabled IS
3098: select APPLICATION_COLUMN_NAME
3099: from FND_DESCR_FLEX_COL_USAGE_VL