APPS.GME_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 615: FROM mtl_system_items_b i, gme_parameters g

611: ,NVL (i.process_supply_locator_id
612: ,g.supply_locator_id)
613: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
614: ,i.restrict_locators_code
615: FROM mtl_system_items_b i, gme_parameters g
616: WHERE i.organization_id = v_org_id
617: AND i.inventory_item_id = v_inventory_item_id
618: AND g.organization_id = v_org_id;
619:

Line 742: FROM mtl_system_items_b i, gme_parameters g

738: ,NVL (i.process_yield_locator_id
739: ,g.yield_locator_id)
740: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
741: ,i.restrict_locators_code
742: FROM mtl_system_items_b i, gme_parameters g
743: WHERE i.organization_id = v_org_id
744: AND i.inventory_item_id = v_inventory_item_id
745: AND g.organization_id = v_org_id;
746:

Line 1411: FROM mtl_system_items_b

1407: -- Bug 13721430 - Add std lot size.
1408: CURSOR cur_common_rules (v_org_id NUMBER, v_inventory_item_id NUMBER)
1409: IS
1410: SELECT std_lot_size, fixed_lead_time, variable_lead_time
1411: FROM mtl_system_items_b
1412: WHERE organization_id = v_org_id
1413: AND inventory_item_id = v_inventory_item_id;
1414:
1415: l_rule_rec cur_common_rules%ROWTYPE;

Line 1899: FROM mtl_system_items_b

1895: /* Bug 5441643 Added NVL condition for location control code*/
1896: CURSOR cur_item_details (v_org_id NUMBER, v_inventory_item_id NUMBER)
1897: IS
1898: SELECT NVL(location_control_code,1), restrict_locators_code
1899: FROM mtl_system_items_b
1900: WHERE organization_id = v_org_id
1901: AND inventory_item_id = v_inventory_item_id;
1902:
1903: org_info_not_provided EXCEPTION;

Line 2118: FROM mtl_system_items_b

2114:
2115: CURSOR cur_item_control
2116: IS
2117: SELECT restrict_subinventories_code
2118: FROM mtl_system_items_b
2119: WHERE organization_id = p_organization_id
2120: AND inventory_item_id = p_inventory_item_id;
2121:
2122: l_item_restict_subinv NUMBER;

Line 2483: FROM gme_material_details d, mtl_system_items_b i

2479: ,x_exception_tbl OUT NOCOPY gme_common_pvt.exceptions_tab) IS
2480: /* Bug 5212165 added line_no in the order by */
2481: CURSOR cur_get_materials IS
2482: SELECT d.*
2483: FROM gme_material_details d, mtl_system_items_b i
2484: WHERE d.batch_id IN (SELECT DISTINCT batch_id
2485: FROM gme_material_details
2486: START WITH batch_id = p_batch_id
2487: CONNECT BY batch_id = PRIOR phantom_id)

Line 2990: FROM mtl_system_items_b

2986: /* Bug 5441643 Added NVL condition for location control code*/
2987: CURSOR cur_item_controls (v_org_id NUMBER, v_inventory_item_id NUMBER)
2988: IS
2989: SELECT NVL(location_control_code,1), restrict_locators_code
2990: FROM mtl_system_items_b
2991: WHERE organization_id = v_org_id
2992: AND inventory_item_id = v_inventory_item_id;
2993:
2994: l_item_loc_control NUMBER;