DBA Data[Home] [Help]

APPS.CSI_COUNTER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 212: from mtl_system_items

208: if p_usage_item_id is not null then
209: begin
210: select 'x'
211: into l_dummy
212: from mtl_system_items
213: where inventory_item_id = p_usage_item_id
214: and organization_id = l_inv_valdn_org_id
215: --and organization_id = cs_std.get_item_valdn_orgzn_id
216: and usage_item_flag = 'Y';

Line 1847: FROM mtl_system_items_b

1843: /* Check if it is an EAM item to get the maint_organization_id */
1844: BEGIN
1845: SELECT eam_item_type
1846: INTO l_eam_item_type
1847: FROM mtl_system_items_b
1848: WHERE inventory_item_id = l_cp_inventory_id
1849: AND organization_id = l_cp_last_vld_org;
1850: EXCEPTION
1851: WHEN NO_DATA_FOUND THEN