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

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

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

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

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

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';
2444: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2445: s_su_stmt_flag VARCHAR2(1) := 'N';
2446: s_su_dun_flag VARCHAR2(1) := 'N';
2447: s_su_legal_flag VARCHAR2(1) := 'N';

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

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';
2444: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2445: s_su_stmt_flag VARCHAR2(1) := 'N';
2446: s_su_dun_flag VARCHAR2(1) := 'N';
2447: s_su_legal_flag VARCHAR2(1) := 'N';
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;

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

2444: s_su_Market_Flag hz_cust_acct_sites_all.Market_Flag%TYPE := 'Y';
2445: s_su_stmt_flag VARCHAR2(1) := 'N';
2446: s_su_dun_flag VARCHAR2(1) := 'N';
2447: s_su_legal_flag VARCHAR2(1) := 'N';
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';

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

2445: s_su_stmt_flag VARCHAR2(1) := 'N';
2446: s_su_dun_flag VARCHAR2(1) := 'N';
2447: s_su_legal_flag VARCHAR2(1) := 'N';
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;

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

2446: s_su_dun_flag VARCHAR2(1) := 'N';
2447: s_su_legal_flag VARCHAR2(1) := 'N';
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;

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

2447: s_su_legal_flag VARCHAR2(1) := 'N';
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;

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

2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2457: s_ADDRESSEE VARCHAR2(50) := NULL;

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

2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2457: s_ADDRESSEE VARCHAR2(50) := NULL;
2458: s_shared_party_site VARCHAR2(1) := 'N';

Line 2474: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;

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

Line 2475: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;

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

Line 2476: t_Market_Flag hz_cust_acct_sites_all.Market_Flag%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;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;

Line 2477: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%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;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;

Line 2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%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;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;

Line 2479: t_territory_id hz_cust_acct_sites_all.territory_id%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;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);

Line 2480: t_territory hz_cust_acct_sites_all.territory%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;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);
2484: -- l_where_clause varchar2(500);

Line 2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;

2477: t_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE;
2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);
2484: -- l_where_clause varchar2(500);
2485: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;

Line 2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;

2478: t_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE;
2479: t_territory_id hz_cust_acct_sites_all.territory_id%TYPE;
2480: t_territory hz_cust_acct_sites_all.territory%TYPE;
2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);
2484: -- l_where_clause varchar2(500);
2485: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2486: l_timezone_id csp_requirement_headers.timezone_id%TYPE;

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 4422: hz_cust_acct_sites_all c_acct_site

4418:
4419: CURSOR site_use_cur IS
4420: SELECT c_site_use.site_use_id, c_acct_site.cust_acct_site_id
4421: FROM hz_cust_site_uses_all c_site_use,
4422: hz_cust_acct_sites_all c_acct_site
4423: WHERE c_site_use.site_use_code = 'SHIP_TO'
4424: AND c_site_use.cust_acct_site_id = c_acct_site.cust_acct_site_id
4425: AND c_acct_site.cust_account_id = p_cust_account_id
4426: AND c_acct_site.party_site_id = p_party_site_id