APPS.WSMPLBJI dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3797: from mtl_system_items_kfv msi

3793:
3794: begin
3795: select 1
3796: into l_no_of_records
3797: from mtl_system_items_kfv msi
3798: where msi.inventory_item_id = v_wlji_item(v_index)
3799: and msi.organization_id = v_wlji_org(v_index)
3800: and msi.lot_control_code = 2;
3801: exception

Line 3815: from mtl_system_items_kfv msi

3811: begin
3812: l_no_of_records := 0;
3813: select 1
3814: into l_no_of_records
3815: from mtl_system_items_kfv msi
3816: where msi.inventory_item_id = v_wlji_item(v_index)
3817: and msi.organization_id = v_wlji_org(v_index)
3818: and msi.serial_number_control_code = 1;
3819: exception

Line 4699: from mtl_system_items_kfv msi

4695: select SERIAL_NUMBER_CONTROL_CODE,
4696: revision_qty_control_code -- Add bug 2963225
4697: into l_dummy,
4698: l_rev_control_code -- Add bug 2963225
4699: from mtl_system_items_kfv msi
4700: where msi.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4701: and msi.organization_id = v_wlji_org(v_index);
4702:
4703: if(l_dummy <> 1) then

Line 7501: from mtl_system_items_kfv

7497:
7498: begin
7499: select unique(concatenated_segments)
7500: into assembly_name
7501: from mtl_system_items_kfv
7502: where inventory_item_id = v_wlji_item(v_index)
7503: and organization_id = v_wlji_org(v_index);
7504: exception
7505: when others then