APPS.WSMPLBJI dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3803: from mtl_system_items_kfv msi

3799:
3800: begin
3801: select 1
3802: into l_no_of_records
3803: from mtl_system_items_kfv msi
3804: where msi.inventory_item_id = v_wlji_item(v_index)
3805: and msi.organization_id = v_wlji_org(v_index)
3806: and msi.lot_control_code = 2;
3807: exception

Line 3821: from mtl_system_items_kfv msi

3817: begin
3818: l_no_of_records := 0;
3819: select 1
3820: into l_no_of_records
3821: from mtl_system_items_kfv msi
3822: where msi.inventory_item_id = v_wlji_item(v_index)
3823: and msi.organization_id = v_wlji_org(v_index)
3824: and msi.serial_number_control_code = 1;
3825: exception

Line 4705: from mtl_system_items_kfv msi

4701: select SERIAL_NUMBER_CONTROL_CODE,
4702: revision_qty_control_code -- Add bug 2963225
4703: into l_dummy,
4704: l_rev_control_code -- Add bug 2963225
4705: from mtl_system_items_kfv msi
4706: where msi.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4707: and msi.organization_id = v_wlji_org(v_index);
4708:
4709: if(l_dummy <> 1) then

Line 7507: from mtl_system_items_kfv

7503:
7504: begin
7505: select unique(concatenated_segments)
7506: into assembly_name
7507: from mtl_system_items_kfv
7508: where inventory_item_id = v_wlji_item(v_index)
7509: and organization_id = v_wlji_org(v_index);
7510: exception
7511: when others then