DBA Data[Home] [Help]

APPS.WIP_EAM_UTILS dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 64: from mtl_system_items_b_kfv msi, mtl_parameters mp

60:
61: if p_asset_group is not null then
62: /* IB Convergence changes */
63: select inventory_item_id into l_inv_item_id
64: from mtl_system_items_b_kfv msi, mtl_parameters mp
65: where msi.concatenated_segments = p_asset_group
66: and msi.organization_id = mp.organization_id
67: and mp.maint_organization_id = p_org_id
68: and rownum = 1;

Line 102: mtl_system_items_b_kfv where

98: -- 3. Asset Activity Id
99: -- Activity should always be assigned to the work order organization
100: if p_asset_activity is not null then
101: select inventory_item_id into l_asset_activity_id from
102: mtl_system_items_b_kfv where
103: concatenated_segments = p_asset_activity
104: and organization_id = p_org_id;
105: end if;
106: