APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on CSI_ITEM_INSTANCES

Line 123: FROM csi_item_instances cii, wip_discrete_jobs wdj

119: AND (end_date_active is NULL OR sysdate <= end_date_active);
120:
121: CURSOR get_asset_number(p_wip_entity_id NUMBER) IS
122: SELECT escapeXMLEam(instance_number) instance_number --for bugfix 10192902
123: FROM csi_item_instances cii, wip_discrete_jobs wdj
124: WHERE decode(wdj.maintenance_object_type,3, wdj.maintenance_object_id,NULL) = cii.instance_id(+)
125: AND wdj.wip_entity_id = p_wip_entity_id;
126:
127: l_is_revision_control BOOLEAN;

Line 143: l_asset_number csi_item_instances.instance_number%TYPE;

139: l_api_version CONSTANT NUMBER:=1;
140: l_api_name VARCHAR2(100);
141: l_unexpected_excep EXCEPTION;
142: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
143: l_asset_number csi_item_instances.instance_number%TYPE;
144: l_yes_no mfg_lookups.meaning%TYPE;
145: BEGIN
146: l_asset_sub_only := FALSE;
147: l_api_name :='Check_Shortage';