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_CUST_ACCT_SITES

Line 1161: from hz_cust_acct_sites hsc1, hz_cust_acct_sites hsc2

1157: select site_use_id
1158: from HZ_CUST_SITE_USES
1159: where cust_acct_site_id in (
1160: select hsc1.cust_acct_site_id
1161: from hz_cust_acct_sites hsc1, hz_cust_acct_sites hsc2
1162: where hsc1.cust_account_id = hsc2.cust_account_id
1163: and hsc2.cust_acct_site_id = v_address_id
1164: and hsc1.cust_acct_site_id <> v_address_id
1165: )

Line 2946: s_Cust_acct_site_id hz_cust_acct_sites_all.Cust_acct_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';
2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';

Line 2947: s_Cust_account_id hz_cust_acct_sites_all.Cust_account_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';
2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2951: s_su_stmt_flag VARCHAR2(1) := 'N';

Line 2948: s_su_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE := 'Y';

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';
2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2951: s_su_stmt_flag VARCHAR2(1) := 'N';
2952: s_su_dun_flag VARCHAR2(1) := 'N';

Line 2949: s_su_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE := 'Y';

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';
2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2951: s_su_stmt_flag VARCHAR2(1) := 'N';
2952: s_su_dun_flag VARCHAR2(1) := 'N';
2953: s_su_legal_flag VARCHAR2(1) := 'N';

Line 2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';

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';
2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2951: s_su_stmt_flag VARCHAR2(1) := 'N';
2952: s_su_dun_flag VARCHAR2(1) := 'N';
2953: s_su_legal_flag VARCHAR2(1) := 'N';
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;

Line 2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;

2950: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2951: s_su_stmt_flag VARCHAR2(1) := 'N';
2952: s_su_dun_flag VARCHAR2(1) := 'N';
2953: s_su_legal_flag VARCHAR2(1) := 'N';
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';

Line 2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';

2951: s_su_stmt_flag VARCHAR2(1) := 'N';
2952: s_su_dun_flag VARCHAR2(1) := 'N';
2953: s_su_legal_flag VARCHAR2(1) := 'N';
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;

Line 2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;

2952: s_su_dun_flag VARCHAR2(1) := 'N';
2953: s_su_legal_flag VARCHAR2(1) := 'N';
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;

Line 2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;

2953: s_su_legal_flag VARCHAR2(1) := 'N';
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;

Line 2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;

2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2962: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2963: s_ADDRESSEE VARCHAR2(50) := NULL;

Line 2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;

2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2962: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2963: s_ADDRESSEE VARCHAR2(50) := NULL;
2964: s_shared_party_site VARCHAR2(1) := 'N';

Line 2980: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;

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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;

Line 2981: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;

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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;

Line 2982: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;

Line 2983: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;

Line 2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;

Line 2985: t_territory_id hz_cust_acct_sites_all.territory_id%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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);

Line 2986: t_territory hz_cust_acct_sites_all.territory%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;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);
2990: -- l_where_clause varchar2(500);

Line 2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;

2983: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE;
2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);
2990: -- l_where_clause varchar2(500);
2991: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;

Line 2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;

2984: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2985: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2986: t_territory hz_cust_acct_sites_all.territory%TYPE;
2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);
2990: -- l_where_clause varchar2(500);
2991: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2992: l_timezone_id csp_requirement_headers.timezone_id%TYPE;

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 3110: from hz_cust_acct_sites_all where cust_acct_site_id = p_cust_acct_site_id;

3106: attribute1,attribute2,attribute3,attribute4,attribute5,
3107: attribute6,attribute7,attribute8,attribute9,attribute10,
3108: attribute11,attribute12,attribute13,attribute14,attribute15,
3109: attribute16,attribute17,attribute18,attribute19,attribute20
3110: from hz_cust_acct_sites_all where cust_acct_site_id = p_cust_acct_site_id;
3111:
3112:
3113: cursor c_check_hz_party_rule is
3114: SELECT 1

Line 3887: select last_update_date into t_last_update_date from hz_cust_acct_sites where CUST_ACCT_SITE_ID = t_cust_acct_site_id;

3883: RAISE EXCP_USER_DEFINED;
3884: END IF;
3885:
3886:
3887: select last_update_date into t_last_update_date from hz_cust_acct_sites where CUST_ACCT_SITE_ID = t_cust_acct_site_id;
3888:
3889:
3890: -- Update the site location and related tables.
3891: arh_addr_pkg.update_row (

Line 4785: FROM HZ_CUST_ACCT_SITES_ALL

4781: end if;
4782:
4783: SELECT org_id
4784: INTO l_org_id
4785: FROM HZ_CUST_ACCT_SITES_ALL
4786: WHERE cust_acct_site_id = p_address_id;
4787:
4788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4827: from hz_cust_acct_sites_all

4823: 'Before calling arp_clas_pkg.insert_po_loc_associations');
4824: end if;
4825:
4826: select cust_account_id into l_cust_acct_id
4827: from hz_cust_acct_sites_all
4828: where cust_acct_site_id = p_address_id;
4829:
4830: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4985: FROM HZ_CUST_ACCT_SITES_ALL

4981: end if;
4982:
4983: SELECT org_id
4984: INTO l_org_id
4985: FROM HZ_CUST_ACCT_SITES_ALL
4986: WHERE cust_acct_site_id = p_address_id;
4987:
4988: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4989: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5283: hz_cust_acct_sites_all c_acct_site

5279:
5280: CURSOR site_use_cur IS
5281: SELECT c_site_use.site_use_id, c_acct_site.cust_acct_site_id
5282: FROM hz_cust_site_uses_all c_site_use,
5283: hz_cust_acct_sites_all c_acct_site
5284: WHERE c_site_use.site_use_code = 'SHIP_TO'
5285: AND c_site_use.status = 'A'
5286: AND c_site_use.cust_acct_site_id = c_acct_site.cust_acct_site_id
5287: AND c_acct_site.cust_account_id = p_cust_account_id

Line 5630: update HZ_CUST_ACCT_SITES_ALL

5626: end if;
5627:
5628: -- Step 4: Update customer account site record to non primary
5629: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5630: update HZ_CUST_ACCT_SITES_ALL
5631: set bill_to_flag = 'Y',
5632: ship_to_flag = 'Y'
5633: where cust_account_id = l_customer_id
5634: and cust_acct_site_id = (

Line 5678: update HZ_CUST_ACCT_SITES_ALL

5674: end if;
5675:
5676: -- Step 6: Update customer account site record to primary
5677: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5678: update HZ_CUST_ACCT_SITES_ALL
5679: set bill_to_flag = 'P',
5680: ship_to_flag = 'P'
5681: where cust_account_id = l_customer_id
5682: and cust_acct_site_id = (

Line 5845: HZ_CUST_ACCT_SITES_ALL orgs,

5841:
5842: cursor check_bill_to_location is
5843: select newu.site_use_id
5844: from HZ_CUST_SITE_USES_ALL orgu,
5845: HZ_CUST_ACCT_SITES_ALL orgs,
5846: HZ_CUST_SITE_USES_ALL newu,
5847: HZ_CUST_ACCT_SITES_ALL news
5848: where orgu.site_use_code = 'BILL_TO'
5849: and orgu.site_use_id = v_ship_bill_site

Line 5847: HZ_CUST_ACCT_SITES_ALL news

5843: select newu.site_use_id
5844: from HZ_CUST_SITE_USES_ALL orgu,
5845: HZ_CUST_ACCT_SITES_ALL orgs,
5846: HZ_CUST_SITE_USES_ALL newu,
5847: HZ_CUST_ACCT_SITES_ALL news
5848: where orgu.site_use_code = 'BILL_TO'
5849: and orgu.site_use_id = v_ship_bill_site
5850: and orgu.cust_acct_site_id = orgs.cust_acct_site_id
5851: and news.party_site_id = orgs.party_site_id