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.GMD_API_GRP dependencies on GMD_FORMULA_SUBSTITUTION

Line 2512: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

2508:
2509: CURSOR Cur_get_substitution IS
2510: SELECT i.original_inventory_item_id, i.start_date, i.substitution_status,
2511: f.formula_id, i.owner_organization_id
2512: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
2513: WHERE i.substitution_id = p_substitution_id
2514: AND i.substitution_id = f.substitution_id;
2515:
2516: CURSOR Cur_check_substitute (V_formula_id NUMBER, V_item_id NUMBER, V_orgn_id NUMBER) IS

Line 2518: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

2514: AND i.substitution_id = f.substitution_id;
2515:
2516: CURSOR Cur_check_substitute (V_formula_id NUMBER, V_item_id NUMBER, V_orgn_id NUMBER) IS
2517: SELECT MIN(i.start_date)
2518: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
2519: WHERE f.formula_id = V_formula_id
2520: AND i.original_inventory_item_id = V_item_id
2521: AND i.owner_organization_id = V_orgn_id
2522: AND i.substitution_id <> p_substitution_id