APPS.RLM_SETUP_TERMS_SV dependencies on RLM_CUST_SHIPTO_TERMS

Line 275: FROM rlm_cust_shipto_terms

271: BEGIN
272:
273: SELECT ship_from_org_id
274: INTO v_ship_from_org_id
275: FROM rlm_cust_shipto_terms
276: WHERE customer_id = x_customer_id
277: AND address_id IS NULL
278: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
279:

Line 291: FROM rlm_cust_shipto_terms

287: -- Get the default
288: BEGIN
289: SELECT ship_from_org_id
290: INTO v_ship_from_org_id
291: FROM rlm_cust_shipto_terms
292: WHERE customer_id = x_customer_id
293: AND address_id IS NULL
294: AND NVL(default_ship_from,'N') = 'Y'
295: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

Line 526: FROM RLM_CUST_SHIPTO_TERMS

522: x_terms_rec.release_time_frame,
523: x_terms_rec.release_time_frame_uom,
524: x_terms_rec.exclude_non_workdays_flag,
525: x_terms_rec.disable_create_cum_key_flag
526: FROM RLM_CUST_SHIPTO_TERMS
527: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
528: AND CUSTOMER_ID = x_customer_id
529: AND ADDRESS_ID is NULL;
530:

Line 682: FROM rlm_cust_shipto_terms

678: --
679: CURSOR c_optional_match_cust(p_shipFromOrgId NUMBER,
680: p_CustomerId NUMBER) IS
681: SELECT match_within_key, match_across_key
682: FROM rlm_cust_shipto_terms
683: WHERE ship_from_org_id = p_shipFromOrgId
684: AND customer_id = p_CustomerId
685: AND address_id IS NULL;
686: --

Line 703: FROM rlm_cust_shipto_terms

699: BEGIN
700:
701: SELECT ship_from_org_id
702: INTO v_ship_from_org_id
703: FROM rlm_cust_shipto_terms
704: WHERE customer_id = x_customer_id
705: AND address_id = x_ship_to_address_id
706: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
707:

Line 719: FROM rlm_cust_shipto_terms

715: -- Get the default
716: BEGIN
717: SELECT ship_from_org_id
718: INTO v_ship_from_org_id
719: FROM rlm_cust_shipto_terms
720: WHERE customer_id = x_customer_id
721: AND address_id = x_ship_to_address_id
722: AND NVL(default_ship_from,'N') = 'Y'
723: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

Line 958: FROM RLM_CUST_SHIPTO_TERMS

954: x_terms_rec.release_time_frame,
955: x_terms_rec.release_time_frame_uom,
956: x_terms_rec.exclude_non_workdays_flag,
957: x_terms_rec.disable_create_cum_key_flag
958: FROM RLM_CUST_SHIPTO_TERMS
959: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
960: AND CUSTOMER_ID = x_customer_id
961: AND ADDRESS_ID = x_ship_to_address_id;
962:

Line 1135: FROM rlm_cust_shipto_terms

1131: --
1132: CURSOR c_optional_match_cust(p_shipFromOrgId NUMBER,
1133: p_CustomerId NUMBER) IS
1134: SELECT match_within_key, match_across_key
1135: FROM rlm_cust_shipto_terms
1136: WHERE ship_from_org_id = p_shipFromOrgId
1137: AND customer_id = p_CustomerId
1138: AND address_id IS NULL;
1139: --

Line 1432: FROM RLM_CUST_SHIPTO_TERMS

1428: x_terms_rec.supplier_shp_calendar_cd,
1429: x_terms_rec.cust_assign_supplier_cd,
1430: x_terms_rec.intransit_calc_basis,
1431: x_terms_rec.disable_create_cum_key_flag --Bugfix 8506409
1432: FROM RLM_CUST_SHIPTO_TERMS
1433: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
1434: AND CUSTOMER_ID = x_customer_id
1435: AND ADDRESS_ID = x_ship_to_address_id;
1436: --

Line 1912: FROM RLM_CUST_SHIPTO_TERMS

1908: x_terms_rec.supplier_shp_calendar_cd,
1909: x_terms_rec.cust_assign_supplier_cd,
1910: x_terms_rec.intransit_calc_basis,
1911: x_terms_rec.disable_create_cum_key_flag --Bugfix 8506409
1912: FROM RLM_CUST_SHIPTO_TERMS
1913: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
1914: AND CUSTOMER_ID = x_customer_id
1915: AND ADDRESS_ID IS NULL;
1916: --