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 673: from hz_party_sites where party_id = p_party_id and status = 'A'));

669: where site_use_type = 'SHIP_TO'
670: and primary_per_type = 'Y'
671: and (party_site_id in
672: (select party_site_id
673: from hz_party_sites where party_id = p_party_id and status = 'A'));
674:
675: BEGIN
676: SAVEPOINT do_create_site_use_PUB;
677:

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

2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;

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

2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:
2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2439: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';

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

2432:
2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2439: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2440: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;

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

2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2439: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2440: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2441: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;

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

2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2439: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2440: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2441: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;
2442: s_su_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE := 'Y';

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

2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;
2439: s_Identifying_address_flag hz_party_sites.Identifying_address_flag%TYPE := 'N';
2440: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_site_id%TYPE := NULL;
2441: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_id%TYPE := NULL;
2442: s_su_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE := 'Y';
2443: s_su_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE := 'Y';

Line 2472: t_party_site_id hz_party_sites.party_site_id%TYPE;

2468: t_last_update_date DATE;
2469: t_party_site_last_update_date DATE;
2470: t_loc_last_update_date DATE;
2471: t_party_id hz_cust_accounts.party_id%TYPE;
2472: t_party_site_id hz_party_sites.party_site_id%TYPE;
2473: t_party_site_number hz_party_sites.party_site_number%TYPE;
2474: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2475: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;
2476: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE;

Line 2473: t_party_site_number hz_party_sites.party_site_number%TYPE;

2469: t_party_site_last_update_date DATE;
2470: t_loc_last_update_date DATE;
2471: t_party_id hz_cust_accounts.party_id%TYPE;
2472: t_party_site_id hz_party_sites.party_site_id%TYPE;
2473: t_party_site_number hz_party_sites.party_site_number%TYPE;
2474: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2475: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;
2476: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE;
2477: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE;

Line 2549: select hz_party_sites_s.nextval from dual;

2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547:
2548: CURSOR l_party_site_number_csr IS
2549: select hz_party_sites_s.nextval from dual;
2550:
2551: CURSOR l_po_loc_association_csr IS
2552: select p.customer_id,
2553: p.address_id,

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

2571: c.translated_customer_name,
2572: c.last_update_date,
2573: ps.last_update_date,
2574: z.last_update_date
2575: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps
2576: 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;
2577:
2578: CURSOR l_inv_loc_csr IS
2579: 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 2587: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';

2583: global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14,
2584: global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20 from hr_locations where location_id = l_inv_location_id;
2585:
2586: CURSOR l_identify_address_flag_csr IS
2587: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';
2588:
2589: Cursor province_enabled IS
2590: select APPLICATION_COLUMN_NAME
2591: from FND_DESCR_FLEX_COL_USAGE_VL