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 2417: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B

2413: l_ingredent_end_date DATE;
2414: l_item_id NUMBER;
2415:
2416: CURSOR cur_item_id IS
2417: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B
2418: WHERE substitution_id = p_substitution_id;
2419: CURSOR cur_count IS
2420: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B
2421: WHERE original_inventory_item_id = l_item_id

Line 2420: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B

2416: CURSOR cur_item_id IS
2417: SELECT original_inventory_item_id FROM GMD_ITEM_SUBSTITUTION_HDR_B
2418: WHERE substitution_id = p_substitution_id;
2419: CURSOR cur_count IS
2420: SELECT count(1) FROM GMD_ITEM_SUBSTITUTION_HDR_B
2421: WHERE original_inventory_item_id = l_item_id
2422: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2423: OR p_exclude_context = 'N'
2424: );

Line 2426: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B

2422: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2423: OR p_exclude_context = 'N'
2424: );
2425: CURSOR cur_s_sub_date IS
2426: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B
2427: WHERE original_inventory_item_id = l_item_id
2428: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2429: OR p_exclude_context = 'N'
2430: );

Line 2432: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B

2428: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2429: OR p_exclude_context = 'N'
2430: );
2431: CURSOR cur_m_sub_date IS
2432: SELECT start_date FROM GMD_ITEM_SUBSTITUTION_HDR_B
2433: WHERE original_inventory_item_id = l_item_id
2434: AND ( (p_exclude_context = 'Y' AND substitution_id <> p_substitution_id)
2435: OR p_exclude_context = 'N'
2436: )

Line 2492: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

2488:
2489: CURSOR Cur_get_substitution IS
2490: SELECT i.original_inventory_item_id, i.start_date, i.substitution_status,
2491: f.formula_id, i.owner_organization_id
2492: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
2493: WHERE i.substitution_id = p_substitution_id
2494: AND i.substitution_id = f.substitution_id;
2495:
2496: CURSOR Cur_check_substitute (V_formula_id NUMBER, V_item_id NUMBER, V_orgn_id NUMBER) IS

Line 2498: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f

2494: AND i.substitution_id = f.substitution_id;
2495:
2496: CURSOR Cur_check_substitute (V_formula_id NUMBER, V_item_id NUMBER, V_orgn_id NUMBER) IS
2497: SELECT MIN(i.start_date)
2498: FROM gmd_item_substitution_hdr_b i, gmd_formula_substitution f
2499: WHERE f.formula_id = V_formula_id
2500: AND i.original_inventory_item_id = V_item_id
2501: AND i.owner_organization_id = V_orgn_id
2502: AND i.substitution_id <> p_substitution_id