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_ACCOUNTS_S

Line 2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active

2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;

Line 2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;

2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';

Line 2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;

2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';

Line 2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;

2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;

Line 2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;

2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;

Line 2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';

2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;

Line 2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';

2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;

Line 2546: select hz_cust_accounts_s.nextval from dual;

2542: CURSOR l_party_number_csr IS
2543: select hz_parties_s.nextval from dual;
2544:
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: