APPS.FLM_KANBAN_PUB dependencies on MTL_SYSTEM_ITEMS

Line 128: FROM mtl_system_items

124: l_exist number;
125: begin
126: SELECT 1
127: INTO l_exist
128: FROM mtl_system_items
129: WHERE inventory_item_id = p_inv_item_id
130: AND organization_id = p_org_id;
131:
132: return true;

Line 176: mtl_system_items_b msi

172: mss.locator_type,
173: msi.location_control_code
174: FROM mtl_parameters mp,
175: mtl_secondary_inventories mss,
176: mtl_system_items_b msi
177: WHERE mp.organization_id = p_organization_id
178: AND mss.secondary_inventory_name = p_subinventory_name
179: AND mss.organization_id = p_organization_id
180: AND msi.inventory_item_id = p_inventory_item_id

Line 538: FROM mtl_system_items msi

534: ,msi.effectivity_control
535: ,msi.inventory_item_flag
536: ,msi.stock_enabled_flag
537: ,msi.inventory_item_status_code
538: FROM mtl_system_items msi
539: WHERE msi.inventory_item_id = p_inventory_item_id
540: AND msi.organization_id = p_organization_id;
541:
542: -- cursor to validate subinventory

Line 1702: FROM mtl_system_items msi

1698: ,msi.effectivity_control
1699: ,msi.inventory_item_flag
1700: ,msi.stock_enabled_flag
1701: ,msi.inventory_item_status_code
1702: FROM mtl_system_items msi
1703: WHERE msi.inventory_item_id = p_inventory_item_id
1704: AND msi.organization_id = p_organization_id;
1705:
1706: -- cursor to validate subinventory

Line 4292: from mtl_system_items_kfv a , mtl_parameters b,

4288: Select concatenated_segments,organization_code,
4289: subinventory_name,locator_id,pull.organization_id
4290: into x_item_name,x_org_code,x_subinventory,l_locator_id,
4291: l_organization_id
4292: from mtl_system_items_kfv a , mtl_parameters b,
4293: mtl_kanban_pull_sequences pull
4294: where a.inventory_item_id = pull.inventory_item_id
4295: and a.organization_id = Pull.organization_id
4296: and b.organization_id = Pull.organization_id

Line 4311: from mtl_system_items_kfv a , mtl_parameters b

4307: end if;
4308: else
4309: Select concatenated_segments,organization_code
4310: into x_item_name,x_org_code
4311: from mtl_system_items_kfv a , mtl_parameters b
4312: where a.inventory_item_id =
4313: p_inventory_item_id
4314: and a.organization_id =
4315: p_organization_id

Line 4483: FROM mtl_system_items_kfv mpk

4479: l_inv_item_id number;
4480: begin
4481: SELECT mpk.inventory_item_id
4482: INTO l_inv_item_id
4483: FROM mtl_system_items_kfv mpk
4484: WHERE mpk.organization_id = p_org_id
4485: AND UPPER(mpk.concatenated_segments) = UPPER (p_conc_segments);
4486:
4487: return l_inv_item_id;