APPS.FLM_KANBAN_PUB dependencies on MTL_PARAMETERS

Line 174: FROM mtl_parameters mp,

170: IS
171: SELECT mp.stock_locator_control_code,
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

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 4343: from mtl_parameters

4339: l_org_id number;
4340: begin
4341: select organization_id
4342: into l_org_id
4343: from mtl_parameters
4344: where organization_code = p_org_code;
4345: return l_org_id;
4346: exception
4347: when others then

Line 4358: from mtl_parameters

4354: l_count number;
4355: begin
4356: select count(organization_id)
4357: into l_count
4358: from mtl_parameters
4359: where organization_id = p_org_id;
4360:
4361: if l_count = 1 then
4362: return false;