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_CUST_ITEM_TERMS

Line 1162: FROM rlm_cust_item_terms

1158: BEGIN
1159:
1160: SELECT ship_from_org_id
1161: INTO v_ship_from_org_id
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

Line 1179: FROM rlm_cust_item_terms

1175: -- Get the default
1176: BEGIN
1177: SELECT ship_from_org_id
1178: INTO v_ship_from_org_id
1179: FROM rlm_cust_item_terms
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'

Line 1392: FROM RLM_CUST_ITEM_TERMS

1388: x_terms_rec.release_rule,
1389: x_terms_rec.release_time_frame,
1390: x_terms_rec.release_time_frame_uom,
1391: x_terms_rec.exclude_non_workdays_flag
1392: FROM RLM_CUST_ITEM_TERMS
1393: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
1394: AND CUSTOMER_ID = x_customer_id
1395: AND ADDRESS_ID = x_ship_to_address_id
1396: AND CUSTOMER_ITEM_ID = x_customer_item_id;

Line 1641: FROM rlm_cust_item_terms

1637: BEGIN
1638:
1639: SELECT ship_from_org_id
1640: INTO v_ship_from_org_id
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

Line 1658: FROM rlm_cust_item_terms

1654: -- Get the default
1655: BEGIN
1656: SELECT ship_from_org_id
1657: INTO v_ship_from_org_id
1658: FROM rlm_cust_item_terms
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'

Line 1871: FROM RLM_CUST_ITEM_TERMS

1867: x_terms_rec.release_rule,
1868: x_terms_rec.release_time_frame,
1869: x_terms_rec.release_time_frame_uom,
1870: x_terms_rec.exclude_non_workdays_flag
1871: FROM RLM_CUST_ITEM_TERMS
1872: WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
1873: AND CUSTOMER_ID = x_customer_id
1874: AND ADDRESS_ID IS NULL
1875: AND CUSTOMER_ITEM_ID = x_customer_item_id;