APPS.EAM_PROCESS_WO_PVT dependencies on CSI_ITEM_INSTANCES

Line 7456: FROM csi_item_instances

7452: l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
7453:
7454: SELECT serial_number, inventory_item_id, last_vld_organization_id
7455: INTO l_serial_number, l_inv_item_id, l_org_id
7456: FROM csi_item_instances
7457: WHERE instance_id = l_eam_wo_rec.maintenance_object_id;
7458:
7459: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Calling api to endate eam genealogy') ; END IF;
7460:

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

11070: wdj.status_type,
11071: ewod.workflow_type,
11072: eam_linear_location_id,
11073: owning_department
11074: FROM wip_discrete_jobs wdj,csi_item_instances cii,eam_work_order_details ewod
11075: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11076: AND wdj.maintenance_object_type = 3
11077: AND wdj.maintenance_object_id = cii.instance_id
11078: AND wdj.wip_entity_id = ewod.wip_entity_id(+)

Line 11584: FROM wip_discrete_jobs wdj,csi_item_instances cii

11580:
11581: SELECT cii.instance_number,cii.instance_id
11582: into l_asset_instance_number,
11583: l_asset_instance_id
11584: FROM wip_discrete_jobs wdj,csi_item_instances cii
11585: WHERE wdj.wip_entity_id = l_eam_wo_comp_rec.wip_entity_id
11586: AND wdj.maintenance_object_type = 3
11587: AND wdj.maintenance_object_id = cii.instance_id
11588: AND cii.serial_number = l_asset_number;

Line 12524: FROM wip_discrete_jobs wdj,csi_item_instances cii

12520: IF l_asset_number IS NOT NULL THEN
12521:
12522: SELECT cii.instance_number,cii.instance_id into l_asset_instance_number,
12523: l_asset_instance_id
12524: FROM wip_discrete_jobs wdj,csi_item_instances cii
12525: WHERE wdj.wip_entity_id = l_eam_op_comp_rec.wip_entity_id
12526: AND wdj.maintenance_object_type = 3
12527: AND wdj.maintenance_object_id = cii.instance_id
12528: AND cii.serial_number = l_asset_number;