DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 29: mtl_system_items_kfv msik,

25: msik.primary_uom_code uom,
26: bic.wip_supply_type,
27: lu.meaning wip_supply_type_disp
28: from bom_inventory_components bic,
29: mtl_system_items_kfv msik,
30: mfg_lookups lu
31: where bic.bill_sequence_id = l_bill_sequence_id
32: and bic.effectivity_date <= sysdate
33: and (bic.disable_date >= sysdate or

Line 63: mtl_system_items_kfv msik,

59: bic.wip_supply_type,
60: lu.meaning wip_supply_type_disp
61: FROM
62: bom_inventory_components bic,
63: mtl_system_items_kfv msik,
64: mfg_lookups lu
65: WHERE
66: bic.bill_sequence_id = l_bill_sequence_id
67: and bic.effectivity_date <= sysdate

Line 102: mtl_system_items_kfv msik,

98: bic.wip_supply_type,
99: lu.meaning wip_supply_type_disp
100: from bom_inventory_components bic,
101: bom_bill_of_materials bbom,
102: mtl_system_items_kfv msik,
103: mfg_lookups lu
104: where bbom.assembly_item_id = i_phantom_item_id
105: and bbom.organization_id = i_organization_id
106: and bbom.alternate_bom_designator is null

Line 322: from mtl_system_items_kfv

318: l_index1 := i_component_table.FIRST;
319: l_index2 := 1;
320: select concatenated_segments
321: into l_assembly_item_name
322: from mtl_system_items_kfv
323: where organization_id = i_organization_id
324: and inventory_item_id = i_asset_group_id;
325: loop
326: if not comp_exists(i_organization_id, i_asset_group_id, i_asset_number,