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_ITEM_SUBSTITUTION_HDR_B

Line 2437: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B

2433: l_ingredent_end_date DATE;
2434: l_item_id NUMBER;
2435:
2436: CURSOR cur_item_id IS
2437: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B
2438: WHERE substitution_id = p_substitution_id;
2439: CURSOR cur_count IS
2440: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B
2441: WHERE original_inventory_item_id = l_item_id

Line 2440: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B

2436: CURSOR cur_item_id IS
2437: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B
2438: WHERE substitution_id = p_substitution_id;
2439: CURSOR cur_count IS
2440: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B
2441: WHERE original_inventory_item_id = l_item_id
2442: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2443: OR p_exclude_context = 'N'
2444: );

Line 2446: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B

2442: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2443: OR p_exclude_context = 'N'
2444: );
2445: CURSOR cur_s_sub_date IS
2446: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B
2447: WHERE original_inventory_item_id = l_item_id
2448: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2449: OR p_exclude_context = 'N'
2450: );

Line 2452: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B

2448: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2449: OR p_exclude_context = 'N'
2450: );
2451: CURSOR cur_m_sub_date IS
2452: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B
2453: WHERE original_inventory_item_id = l_item_id
2454: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2455: OR p_exclude_context = 'N'
2456: )

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