APPS.INV_AUTODETAIL dependencies on MTL_SYSTEM_ITEMS

Line 51: -- Fetches picking rule. First from mtl_system_items. If absent there, tries

47: -- Functions and Procedures
48: --
49: -- --------------------------------------------------------------------------
50: -- What does it do:
51: -- Fetches picking rule. First from mtl_system_items. If absent there, tries
52: -- mtl_parameters.
53: -- --------------------------------------------------------------------------
54: PROCEDURE get_pick_rule
55: ( p_organization_id IN NUMBER

Line 70: -- find rule from mtl_system_items

66: l_rule_id NUMBER;
67: BEGIN
68:
69: x_return_status := fnd_api.g_ret_sts_success ;
70: -- find rule from mtl_system_items
71: IF ((nvl(g_inventory_item_id,-9999) <> p_inventory_item_id) OR
72: (nvl(g_organization_id,-9999) <> p_organization_id)) THEN
73: IF inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) THEN
74: g_rule_id := inv_cache.item_rec.picking_rule_id;

Line 1218: l_item_rec MTL_SYSTEM_ITEMS%ROWTYPE;

1214:
1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1216: l_to_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1217: l_org_rec MTL_PARAMETERS%ROWTYPE;
1218: l_item_rec MTL_SYSTEM_ITEMS%ROWTYPE;
1219: l_ret_value NUMBER;
1220: l_move_order_type NUMBER;
1221: --Bug Number 3449739
1222: l_indivisible_flag VARCHAR2(10) := 'N';

Line 1244: FROM MTL_SYSTEM_ITEMS

1240: WHERE organization_id = p_request_line_rec.organization_id;
1241:
1242: CURSOR l_item_cursor IS
1243: SELECT *
1244: FROM MTL_SYSTEM_ITEMS
1245: WHERE inventory_item_id = p_request_line_rec.inventory_item_id
1246: AND organization_id = p_request_line_rec.organization_id;
1247:
1248: CURSOR c_move_order_type IS