APPS.EAM_PROCESS_WO_PVT dependencies on CSI_ITEM_INSTANCES

Line 7882: FROM csi_item_instances

7878: l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
7879:
7880: SELECT serial_number, inventory_item_id, last_vld_organization_id
7881: INTO l_serial_number, l_inv_item_id, l_org_id
7882: FROM csi_item_instances
7883: WHERE instance_id = l_eam_wo_rec.maintenance_object_id;
7884:
7885: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('EAM_PROCESS_WO_PVT.WORK_ORDER : Calling api to endate eam genealogy') ; END IF;
7886:

Line 11692: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod

11688: wdj.status_type,
11689: ewod.workflow_type,
11690: eam_linear_location_id,
11691: owning_department
11692: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod
11693: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11694: AND wdj.maintenance_object_type = 3
11695: AND wdj.maintenance_object_id = cii.instance_id
11696: AND wdj.wip_entity_id = ewod.wip_entity_id(+)

Line 12217: FROM wip_discrete_jobs wdj,csi_item_instances cii

12213:
12214: SELECT cii.instance_number,cii.instance_id
12215: into l_asset_instance_number,
12216: l_asset_instance_id
12217: FROM wip_discrete_jobs wdj,csi_item_instances cii
12218: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
12219: AND wdj.maintenance_object_type = 3
12220: AND wdj.maintenance_object_id = cii.instance_id
12221: AND cii.serial_number = l_asset_number;

Line 13194: FROM wip_discrete_jobs wdj,csi_item_instances cii

13190: IF l_asset_number IS NOT NULL THEN
13191:
13192: SELECT cii.instance_number,cii.instance_id into l_asset_instance_number,
13193: l_asset_instance_id
13194: FROM wip_discrete_jobs wdj,csi_item_instances cii
13195: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
13196: AND wdj.maintenance_object_type = 3
13197: AND wdj.maintenance_object_id = cii.instance_id
13198: AND cii.serial_number = l_asset_number;