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 > SYSDATE);

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 1639: FROM rlm_cust_item_terms

1635: BEGIN
1636:
1637: SELECT ship_from_org_id
1638: INTO v_ship_from_org_id
1639: FROM rlm_cust_item_terms
1640: WHERE customer_id = x_customer_id
1641: AND address_id IS NULL
1642: AND customer_item_id = x_customer_item_id
1643: AND (inactive_date IS NULL OR inactive_date > SYSDATE);

Line 1656: FROM rlm_cust_item_terms

1652: -- Get the default
1653: BEGIN
1654: SELECT ship_from_org_id
1655: INTO v_ship_from_org_id
1656: FROM rlm_cust_item_terms
1657: WHERE customer_id = x_customer_id
1658: AND address_id IS NULL
1659: AND customer_item_id = x_customer_item_id
1660: AND NVL(default_ship_from,'N') = 'Y'

Line 1869: FROM RLM_CUST_ITEM_TERMS

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