APPS.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 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 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 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;