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.OKS_AUTO_REMINDER dependencies on OKX_SYSTEM_ITEMS_V

Line 1244: FROM okx_system_items_v mtl,

1240:
1241: CURSOR c1
1242: IS
1243: SELECT mtl.NAME
1244: FROM okx_system_items_v mtl,
1245: okx_cust_prod_v cp
1246: WHERE mtl.id1 = cp.inventory_item_id
1247: AND mtl.organization_id = p_inv_org_id
1248: AND cp.customer_product_id = p_object_id;

Line 1341: FROM okx_system_items_v mtl,

1337: IS
1338: CURSOR l_service_csr
1339: IS
1340: SELECT NAME
1341: FROM okx_system_items_v mtl,
1342: okc_k_items itm
1343: WHERE mtl.id1 = itm.object1_id1
1344: AND mtl.id2 = itm.object1_id2
1345: AND itm.cle_id = p_line_id

Line 1348: l_service_name okx_system_items_v.NAME%TYPE;

1344: AND mtl.id2 = itm.object1_id2
1345: AND itm.cle_id = p_line_id
1346: AND itm.dnz_chr_id = p_contract_id;
1347:
1348: l_service_name okx_system_items_v.NAME%TYPE;
1349: BEGIN
1350: OPEN l_service_csr;
1351:
1352: FETCH l_service_csr