APPS.EAM_MATERIAL_VALIDATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 108: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, wip_entities we, csi_item_instances cii

104: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' );
106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
107: l_sql_stmt := ' SELECT wdj.wip_entity_id
108: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, wip_entities we, csi_item_instances cii
109: WHERE wdj.wip_entity_id = ewod.wip_entity_id
110: AND wdj.wip_entity_id=we.wip_entity_id
111: AND wdj.maintenance_object_id = cii.instance_id
112: AND wdj.maintenance_object_type = 3

Line 131: FROM csi_item_instances

127: BEGIN
128: --added bug 10192902
129: SELECT instance_id
130: INTO l_instance_id
131: FROM csi_item_instances
132: WHERE
133: instance_number=p_asset_number;
134:
135: EXCEPTION WHEN NO_DATA_FOUND THEN