APPS.EAM_WORKORDER_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

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 164: mtl_system_items_b msi

160: for which it is being summoned. */
161: SELECT
162: NVL(msi.eam_item_type,-1) INTO l_eam_item_type
163: FROM
164: mtl_system_items_b msi
165: WHERE
166: msi.inventory_item_id = i_asset_group_id
167: and organization_id = i_organization_id;
168:

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,

Line 1800: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;

1796: /* Function to get rebuild description in eam_work_orders_v*/
1797:
1798: FUNCTION get_rebuild_description( p_rebuild_item_id NUMBER, p_organization_id NUMBER)
1799: return VARCHAR2 IS
1800: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;
1801: CURSOR get_description IS
1802: SELECT description
1803: FROM MTL_SYSTEM_ITEMS
1804: WHERE inventory_item_id = p_rebuild_item_id

Line 1803: FROM MTL_SYSTEM_ITEMS

1799: return VARCHAR2 IS
1800: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;
1801: CURSOR get_description IS
1802: SELECT description
1803: FROM MTL_SYSTEM_ITEMS
1804: WHERE inventory_item_id = p_rebuild_item_id
1805: AND organization_id = p_organization_id ;
1806: BEGIN
1807: OPEN get_description ;