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.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS

Line 525: FROM mtl_system_items_b i, gme_parameters g

521: ,NVL (i.process_supply_locator_id
522: ,g.supply_locator_id)
523: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
524: ,i.restrict_locators_code
525: FROM mtl_system_items_b i, gme_parameters g
526: WHERE i.organization_id = v_org_id
527: AND i.inventory_item_id = v_inventory_item_id
528: AND g.organization_id = v_org_id;
529:

Line 652: FROM mtl_system_items_b i, gme_parameters g

648: ,NVL (i.process_yield_locator_id
649: ,g.yield_locator_id)
650: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
651: ,i.restrict_locators_code
652: FROM mtl_system_items_b i, gme_parameters g
653: WHERE i.organization_id = v_org_id
654: AND i.inventory_item_id = v_inventory_item_id
655: AND g.organization_id = v_org_id;
656:

Line 756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE

752: END get_yield_defaults;
753:
754: PROCEDURE construct_material_detail (
755: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
758: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
759: ,x_return_status OUT NOCOPY VARCHAR2)
760: IS

Line 1320: FROM mtl_system_items_b

1316: IS
1317: CURSOR cur_common_rules (v_org_id NUMBER, v_inventory_item_id NUMBER)
1318: IS
1319: SELECT fixed_lead_time, variable_lead_time
1320: FROM mtl_system_items_b
1321: WHERE organization_id = v_org_id
1322: AND inventory_item_id = v_inventory_item_id;
1323:
1324: l_rule_rec cur_common_rules%ROWTYPE;

Line 1793: FROM mtl_system_items_b

1789: /* Bug 5441643 Added NVL condition for location control code*/
1790: CURSOR cur_item_details (v_org_id NUMBER, v_inventory_item_id NUMBER)
1791: IS
1792: SELECT NVL(location_control_code,1), restrict_locators_code
1793: FROM mtl_system_items_b
1794: WHERE organization_id = v_org_id
1795: AND inventory_item_id = v_inventory_item_id;
1796:
1797: org_info_not_provided EXCEPTION;

Line 2012: FROM mtl_system_items_b

2008:
2009: CURSOR cur_item_control
2010: IS
2011: SELECT restrict_subinventories_code
2012: FROM mtl_system_items_b
2013: WHERE organization_id = p_organization_id
2014: AND inventory_item_id = p_inventory_item_id;
2015:
2016: l_item_restict_subinv NUMBER;

Line 2124: FROM mtl_system_items_kfv

2120:
2121: CURSOR cur_item_no (v_org_id NUMBER, v_inventory_item_id NUMBER)
2122: IS
2123: SELECT concatenated_segments
2124: FROM mtl_system_items_kfv
2125: WHERE organization_id = v_org_id
2126: AND inventory_item_id = v_inventory_item_id;
2127:
2128: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

Line 2368: FROM gme_material_details d, mtl_system_items_b i

2364: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab) IS
2365: /* Bug 5212165 added line_no in the order by */
2366: CURSOR cur_get_materials IS
2367: SELECT d.*
2368: FROM gme_material_details d, mtl_system_items_b i
2369: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2370: FROM gme_material_details
2371: START WITH batch_id = p_batch_id
2372: CONNECT BY batch_id = PRIOR phantom_id)

Line 2390: FROM mtl_system_items_kfv

2386: IS
2387: SELECT concatenated_segments, NVL(location_control_code,1) location_control_code,
2388: restrict_locators_code, primary_uom_code,
2389: reservable_type
2390: FROM mtl_system_items_kfv
2391: WHERE organization_id = v_org_id
2392: AND inventory_item_id = v_inventory_item_id;
2393:
2394: CURSOR cur_get_onhand (

Line 2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;

2439: l_subinventory VARCHAR2 (10);
2440: l_return_status VARCHAR2 (1);
2441: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2442: --FPbug#4912179
2443: --l_item_rec mtl_system_items_kfv%ROWTYPE;
2444: l_item_rec cur_get_item%ROWTYPE;
2445: l_exception_rec gme_exceptions_gtmp%ROWTYPE;
2446: setup_failure EXCEPTION;
2447: get_open_qty_err EXCEPTION;

Line 2826: FROM mtl_system_items_b

2822: /* Bug 5441643 Added NVL condition for location control code*/
2823: CURSOR cur_item_controls (v_org_id NUMBER, v_inventory_item_id NUMBER)
2824: IS
2825: SELECT NVL(location_control_code,1), restrict_locators_code
2826: FROM mtl_system_items_b
2827: WHERE organization_id = v_org_id
2828: AND inventory_item_id = v_inventory_item_id;
2829:
2830: l_item_loc_control NUMBER;