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.GMDFMVAL_PUB dependencies on DUAL

Line 582: FROM sys.dual

578: iret NUMBER;
579:
580: CURSOR locked_val_cur(pfmeff_id NUMBER) IS
581: SELECT 1
582: FROM sys.dual
583: WHERE EXISTS (SELECT 1
584: FROM cm_cmpt_dtl
585: WHERE fmeff_id = pfmeff_id
586: AND rollover_ind = 1);

Line 1540: FROM DUAL;

1536: x_new_substitution_id := subs_rec.substitution_id;
1537: END IF;
1538: SELECT gmd_formula_substitution_s.nextval
1539: INTO x_newformsubs_id
1540: FROM DUAL;
1541:
1542: -- End of bug# 5354649
1543:
1544: -- Copy all substitution list specific to old formula into

Line 2276: FROM SYS.DUAL

2272: -------------------------------------------------------------------
2273: --Cursor fetches 1 if context formula has experied item(s)
2274: CURSOR cur_check_expr(p_org_id NUMBER) IS
2275: SELECT 1
2276: FROM SYS.DUAL
2277: WHERE EXISTS (SELECT 1
2278: FROM fm_matl_dtl d, mtl_system_items_b i
2279: WHERE recipe_enabled_flag = 'Y'
2280: AND i.ORGANIZATION_ID = p_org_id

Line 2362: FROM SYS.DUAL

2358: -------------------------------------------------------------------
2359: --Cursor fetches 1 if context formula has experied item(s)
2360: CURSOR cur_check_inactive IS
2361: SELECT 1
2362: FROM SYS.DUAL
2363: WHERE EXISTS (SELECT 1
2364: FROM fm_matl_dtl d, mtl_system_items_b i
2365: WHERE d.formula_id = V_formula_id
2366: AND i.inventory_item_id = d.inventory_item_id