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.RLM_SETUP_TERMS_SV dependencies on RLM_DP_SV

Line 278: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

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:
280: -- Proceed
281: IF (l_debug <> -1) THEN
282: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

Line 295: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

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
296:
297: -- Proceed
298: IF (l_debug <> -1) THEN
299: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

Line 535: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830

531: /* By default, inactive_date is NULL */
532: --
533: IF x_terms_rec.inactive_date is NOT NULL THEN
534: --
535: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830
536: --
537: raise e_inactive_record;
538: --
539: END IF;

Line 706: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

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:
708: -- Proceed
709: IF (l_debug <> -1) THEN
710: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id);

Line 723: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

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
724:
725: -- Proceed
726: IF (l_debug <> -1) THEN
727: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id);

Line 965: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830

961: AND ADDRESS_ID = x_ship_to_address_id;
962:
963: /* By default, inactive_date is NULL */
964: IF x_terms_rec.inactive_date is NOT NULL THEN
965: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830
966: raise e_inactive_record;
967: END IF;
968: END IF;
969: --

Line 1166: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

1162: FROM rlm_cust_item_terms
1163: WHERE customer_id = x_customer_id
1164: AND address_id = x_ship_to_address_id
1165: AND customer_item_id = x_customer_item_id
1166: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1167:
1168: -- Proceed
1169: IF (l_debug <> -1) THEN
1170: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

Line 1184: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

1180: WHERE customer_id = x_customer_id
1181: AND address_id = x_ship_to_address_id
1182: AND customer_item_id = x_customer_item_id
1183: AND NVL(default_ship_from,'N') = 'Y'
1184: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1185:
1186: -- Proceed
1187: IF (l_debug <> -1) THEN
1188: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

Line 1444: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830

1440: END IF;
1441: --
1442: /* By default, inactive_date is NULL */
1443: IF x_terms_rec.inactive_date is NOT NULL THEN
1444: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830
1445: raise e_inactive_record;
1446: END IF;
1447: END IF;
1448: --

Line 1645: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

1641: FROM rlm_cust_item_terms
1642: WHERE customer_id = x_customer_id
1643: AND address_id IS NULL
1644: AND customer_item_id = x_customer_item_id
1645: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1646:
1647: -- Proceed
1648: IF (l_debug <> -1) THEN
1649: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

Line 1663: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830

1659: WHERE customer_id = x_customer_id
1660: AND address_id IS NULL
1661: AND customer_item_id = x_customer_item_id
1662: AND NVL(default_ship_from,'N') = 'Y'
1663: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1664:
1665: -- Proceed
1666: IF (l_debug <> -1) THEN
1667: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

Line 1924: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830

1920: END IF;
1921: --
1922: /* By default, inactive_date is NULL */
1923: IF x_terms_rec.inactive_date is NOT NULL THEN
1924: IF x_terms_rec.inactive_date <= nvl(rlm_dp_sv.g_dsp_start_time,sysdate) THEN --Bugfix 10053830
1925: raise e_inactive_record;
1926: END IF;
1927: END IF;
1928: --