APPS.AHL_UMP_NONROUTINES_PVT dependencies on CSI_ITEM_INSTANCES

Line 187: FROM csi_item_instances

183: inv_master_organization_id
184: INTO p_x_nonroutine_rec.inventory_item_id,
185: l_service_request_rec.inventory_item_id,
186: l_service_request_rec.inventory_org_id
187: FROM csi_item_instances
188: WHERE instance_id = p_x_nonroutine_rec.instance_id;
189:
190: l_service_request_rec.customer_product_id := p_x_nonroutine_rec.instance_id;
191: l_service_request_rec.creation_program_code := 'AHL_NONROUTINE';

Line 681: FROM csi_item_instances

677: SELECT p_x_nonroutine_rec.inventory_item_id,
678: inv_master_organization_id
679: INTO l_service_request_rec.inventory_item_id,
680: l_service_request_rec.inventory_org_id
681: FROM csi_item_instances
682: WHERE instance_id = p_x_nonroutine_rec.instance_id;
683:
684: l_service_request_rec.customer_product_id := p_x_nonroutine_rec.instance_id;
685: l_service_request_rec.creation_program_code := 'AHL_NONROUTINE';

Line 2883: FROM csi_item_instances csi

2879: -- There is no need to join with MTL/HOU since this is just a instance_number to instance_id validation,
2880: -- the check for whether the instance exists on an active unit is being done in Validate_UE_Details
2881: SELECT csi.instance_id
2882: INTO p_x_nonroutine_rec.instance_id
2883: FROM csi_item_instances csi
2884: WHERE trunc(nvl(csi.active_start_date, sysdate)) <= trunc(sysdate) and
2885: trunc(nvl(csi.active_end_date, sysdate+1)) > trunc(sysdate) and
2886: csi.instance_number = p_x_nonroutine_rec.instance_number;
2887: EXCEPTION

Line 2990: FROM csi_item_instances

2986:
2987: -- Retrieve instance customer id
2988: SELECT NVL(OWNER_PARTY_ID, -1)
2989: INTO l_instance_owner_id
2990: FROM csi_item_instances
2991: WHERE instance_id = p_x_nonroutine_rec.instance_id;
2992:
2993: -- Validate and default customer...
2994: IF (p_x_nonroutine_rec.customer_name IS NOT NULL AND p_x_nonroutine_rec.customer_name <> FND_API.G_MISS_CHAR)