APPS.FLM_KANBAN_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

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;